Looking up and connecting service location to a customer
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.