AnsweredAssumed Answered

How to select what related records to show.,...

Question asked by 100 on Jul 27, 2010
Latest reply on Jul 27, 2010 by philmodjunk

Title

How to select what related records to show.,...

Post

Hi,

I have a table "Suppliers" and each supplier may have many "SupplierContacts". However, each SupplierContact may be related to many suppliers. So, with my SQL background I created a relatinoship like this:

[Suppliers :: SupplierID], [SupplierContactsXRef ::SupplierXRefID, SupplierID, SupplierContactID], [SupplierContacts :: SupplierContactID]

In this way I would normally in access/sql server etc be able to do a join to link in both directions. Do, how the heck to do it in FM? ... I want to have a Suppliers form that has a contacts portal control and all related contacts showing in that control.

Thanks,

Allen.

Outcomes