hey new to the group :) I have an issue with a db i created in controling when a form can be printed and not allowing duplicate values in a field. Let me explain what im trying to do and see if anyone can help.
I have created this db to control an assembly process of a large part basically each part has a large amount of components that go into it. I have a form that inputs all the data into a main table also each individual component has restrictions depending on the part (some can have the same ID or testing data some cant) so i used the no duplicate option in properties. My question on this is, is there a way to know which of the fields has a duplicate value right now you have to delete each field until you find it.(i jump to the next form and if their is a popup i scan through the fields till i find the problem). My next issue is after all the data is input on the part this form is sent to the customer. I cant require every field to be entered because it is all done at different times, but i want to put a control in place to be sure all the data is input before it is able to be printed for the customer. Any help would be greatly appreciated
