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,