How to select what related records to show.,...
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.