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,

 

ed

Outcomes