Finding matching data from two tables

[lp560]

I've just started using FM again, this is probably a simple question!

I have two tables one is called "Sellers" the other "Buyers".

When I add a seller to the DB I would like to perform a search so that any matching Buyers will pop up.

There will be two fields, both need to match, the fields are:

Aircraft Manufacturer

Aircraft Model

Any advice will be greatly appreciated :thumbup:

[Fitch]

It depends what you envision when you say "pop up."

With FileMaker 10, you can trigger a script that runs when you exit either field. The script should first check that both fields are not empty, and then bring up a new window and run a search.

Alternatively, you could define a relationship based on the two fields, and show matching buyers in a portal.

[lp560]

Using a relationship, I've tried but failed!

I've tried the following: Manage > Database > Relationships > I've then dragged Aircraft Manufacturer & Model over to the other fields in the Sellers table.

Thats as far as I've got, obviously there is another step but I'm not sure where to go from there.

Thanks

[Fitch]

On your Sellers layout, make a portal based on the related Buyers table occurrence that you just described.

When you enter Aircraft Manufacturer & Model on a Seller record, once you exit those fields any matching Buyers should appear in the portal.