AnsweredAssumed Answered

Looking up and connecting service location to a customer

Question asked by Kat11_1 on Feb 25, 2011
Latest reply on Feb 28, 2011 by Kat11_1

Title

Looking up and connecting service location to a customer

Post

I have two tables. Customers and Service Locations with a unique id field in each. I created a table occurrence for each (CustomerLocations) and (ServiceLocationCustomers). A Customer can have one or more service locations.

I would like to be create a layout in whicch I would find an existing customer (or add a new one)  and be able to look up and associate service location(s) with this customer.

I am not quite sure how to go about it. What kind of relationships I set up between the table occurances? (Do I just need one Table Occurance Customer Locations?

Do I use a portal to show all the possible locations? If I can show the possible locations, how do I then "select" or assign the location to the customer?

Or do I use Value List based on a field in the Service Location Customers table? How do I then "select" or assign the location to the customer?

I am a novice user so this is quite a problem for me. Thanks for your suggestions and help.

Outcomes