getting data from 2 databases into a third

[gameboy1]

Hi,

I have a jobticket database. On the jobticket database is a field for the supplier's name. I also have a 2nd database that holds all the suppliers details.

I have a 3rd database for ordering. When I go to the ordering page, The name of the supplier is there (from the 1st DB). My problems is that I can't get the suppliers address (from the 2nd DB) to appear. I had this working in a previous version of FMP, but now I can't remember how to do it.

Can someone give me some help please.

gameboy1

[SlimJim]

I assume the three tables are related: Table3 to Table1 by JobTicket Number, Table1 to Table2 by Suppliers name. This gives an implied relationship from Table3 to Table1 so if you have a layout on Table3 you can insert related fields from Table2, for example the suppliers address.

[SlimJim]

Correction: The implied relationship in the previous post should be Table3 to Table2