At the moment I have a number of tables but most of the data is on one table which I have designed a form from, problem I have found is if I change or amend any part of the table the form stops working or askes the user to enter data which is not needed.
My thinking was to run querys to get the data, for example one for client names and one for products, then build the form using a linked query by doing this I would be able to go into the query to remove the field before I update the table so I hope stop the problem.
Any help would be great as I would like to get this sorted today.