Choose a RELATIONSHIP

[nik.be]

Hi everyone,

I am in a spot of trouble. I'm trying to set up a DB which contains SUPPLIERS, CLIENTS, ESTIMATES, INVOICES and PURCHASES.

I have managed to create relationships that allows me to create SUPPLIERS from CLIENTS. I can create ESTIMATES from CLIENTS and then use those details to make INVOICES. However I have a problem with PURCHASES. What I would like to do is to be able to access any existing ESTIMATE (which is already related to a CLIENT) and from a drop-down menu containing the list of all SUPPLIERS, choose one which will then be linked to a newly created PURCHASE. I have attached below a siplified FM file for you to have a look at. Please help. Thanks. Nik

Link to Test File