Two databases connecting

[matt_v]

I'm in the process of making some modifications to the FileMaker Business Productivity solution to customize it to our use.

I've got one section in the projects area where I would like to grab some data from the contacts section regarding the staffing of an event (phone number, shirt size). I've set up a relationship between the event staff table and the contacts table, but the data is not appearing. Am I at least on the right track here?

-Matt

[AudioFreak]

Hi Matt,

Sounds like you are on the right track. If your relationship is set up properly you have to decide whether you want to lookup the data and have it "entered" in the staff table. Or just display it so you can see it.

With a lookup when the keyfield has the correct data enter the fields set to lookup from the other table will populate with the related data.

Or you can just put the fields from the contact table on the layout and if the relationship matches the correct info will be "displayed" but still lives in the contact table.

Eg. Lookups are nice for things such as a Shipping Address on an invoice cuz the address might change so a lookup grabs the current shipping address but will not change the address on prior invoices.

HTH

Michael