Recent content by beardo

Ok the quantity problem sorted, stupidity on my account, but still can't get the New? to update when the machine_ID is updated?

Ah no, pbaldy, what you said is correct. That is what is set in the settings of Machine_ID Now it has done something. The first column on the form is bringing in machine_ID as it should. But now Quantity, is also being updates with Machines_ID instead of being empty and ready for user...

OK Yes it does now say: SELECT [Machines].[Machine ID], [Machines].[New?] FROM Machines; And I have set the other parameters as you said. I get the correct values up but it is being pulled from the Machine_ID field from the 'Machines' table instead of the Orders_Machines table, is this...

Hi, Thanks for your reply. However I'm afraid I don't understand the second part of your reply? And when I put in the row source for the Machine_ID combo box it just brings up YES, NO, YES, NO etc (The values in New?) Thanks Richard

Hi, I am having problems bringing in data from another table in a form. I currently have 4 tables that are relevant. CUSTOMERS, ORDERS, ORDERS_MACHINES and MACHINES (The Orders_Machines table is used to break down the many to many relationship and includes a list of machines and the quantity...