madslp

That clarified a great deal! Very helpful to access a file. Sorry, I hadn't understood that the Buyer and Seller were copies of the Company table (in both solutions). Thanks again!

Thank you both for helping out! I think I agree with 'comment' that connecting only through a buyer and seller table will make it difficult to display all transactions for a company, both as seller and as buyer. It would also entail duplicating data, which I hope to avoid. I have therefore tried to use the solution with a calculated cCompanyID field in Transactions linking to Companies, as suggested by 'comment' and shown in the figure in the previous post. But there's something I'm not doing right. Say in a Company Detail layout, how could I get all transactions? Using the List(BuyerID;SellerID), I am currently only able to view transactions when the Company is buyer.

Hi, I'm new to both building databases and Filemaker, but am trying to set up a simple database for managing transactions. Currently I have two tables, 'Company' and 'Transaction'. To avoid duplicates I have tried to store information about both buyer and seller in the Company table, i.e. one primary key referencing two foreign keys in the same table. So I've used Company_ID as the primary key in the Company table and link this to two foreign keys (Buyer_ID and Seller_ID) in the Transaction table. This is where the problem arises. I am not able to access any information in the Company table from the Buyer_ID or Seller_ID. This only works if I use only one foreign key, but then I only get information about either buyer or seller. I have also tried to create a copy of the Company table, and then link from Company1 to Buyer_ID and Company2 to Seller_ID, but that didn't work for the layout showing details about each company (it would only show transactions where the company was buyer if associated with the original company table etc.). If my problem is at all comprehensible, any ideas on how to solve it?