December 1, 200520 yr 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
Create an account or sign in to comment