Dawana

Greetings, I have a data set with a store with many locations Search form store name manager name Store A = 1 manager Store B = 1 manager Store C = multiple managers for example -CORRECT Store A 123 Somewhere Ave. wish, RR 80012 manager: Popicle Pop - CORRECT Store B 456 Summer Time Hopefully, DD 80014 Manager: Groovy Man The Problem: When I select Store C The results return all the stores assigned to Store C with manager names, however the stores name and address are duplicated, the manager names are unique. Store C - (results returned) 788 Okaywhereissummer Rd AwwwMan, FF 80022 Manager: Boogie Wonderland Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 manager: Popicle Pop Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 Manager: Lucy Lunchmeat Store C 788 HereIam Rd AwwwMan, FF 80022 Manager: Dolly DoorKnob Store C 788 HereIam Rd AwwwMan, FF 80022 Manager: Kick Rocks Store c 788 HereIam Rd AwwwMan, FF 80022 manager: Popicle Pop ***The goal: I would like the results to return unique store locations, (so that means all the managers associated to that one store are displayed), and create a link the user will click on and route to the details page, this page will display a snippet of information pertaining to each manager at that store. (see below) Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 (link > click to details page with snippets of information of the managers associated to this location only) Manager: Lucy Lunchmeat Manager: Boogie Wonderland manager: Popicle Pop Store C 788 HereIam Rd AwwwMan, FF 80022 (link > click to details page with snippets of information of the managers associated to this location only) Manager: Dolly DoorKnob Manager: Kick Rocks manager: Popicle Pop I also need to be able to search on the manager name individually, this result set would return all the stores the manager is assigned to and create a link to the details page that will display a snippet of information pertaining to manager selected. Select manager > Popicle Pops Store C 788 HereIam Rd AwwwMan, FF 80022 (Name: Popicle Pops Link) Store C 788 Okaywhereissummer Rd AwwwMan, FF 80022 (Name: Popicle Pops Link) Whew! Is this possible? I have researched JavaScript (case - switch ) , which I think can be a option, only I don't know where to begin. I'm stuck. Help !! Ideas, Any suggestions on how to achieve this complex search form is greatly appreciated. Hopefully, it's a simple solution. Thanks Dawana

I have a gallery report datapage with a Search form and Results displaying on the same page in the results I am using a (specific data field) to link to the details page I want to create a custom link - (click here for Ingredients info) the user clicks on the custom link which takes user to another details page How do I set this up where the link is going to another details page? Any help is appreciated! Thank you --example-- Butter Pecan Ice Cream --> Link to Detail page (Specific data field) - THIS WORKS! 1234 Somewhere Lane City, state, 12345 Website: www.ButterPecan.com --> go to website (opens in another window) THIS WORKS! custom link --> click here for Ingredient info (HELP!)