AnsweredAssumed Answered

creating many to many records

Question asked by edmalloy on Mar 15, 2012
Latest reply on Mar 16, 2012 by rhlilienkamp

Hi all,


I am an experienced database person, but new to Filemaker Pro.


I have two two tables: vehicles and service_centers. I want to be able to select a vehicle AND select a service_and and then insert a new record in the appointments table which references the vehicle and the service_center.


I can create a layout to "find" a vehicle, but I don't know how to add a list of service_centers to that layout. Can I create a portal for service_centers, even though there is no linkage between vehicles and service_centers. Help!


Once I select the vehicle and the service_center. how do I insert their keys into the appointments table? I'm thiking that I should be able to copy the keys into (global?) variables, and then copy the variable value into the newly inserted appointment record, but I can't find a script command that inserts a varialble into a record's field.


Any assistance will be greatly appreciated.


thanks in advance,