One to One relationship between two forms via lookup field - Strategy for no duplicates
Sorry, newbie question. I have two forms containing fields that relate to single jobs. My forms are divided by company segments (Engineering & Production). I can link the forms via a lookup field (job number) but I am having trouble because I cannot seem to figure out how to exclude duplicate entries in my second form.
My Engineering form has the Job Number field set to no duplicates. My lookup field resides in Production form and is a required entry. Problem I have is you cannot tell if there is already a record created in the Production table. If a user goes to update or enter new information they are creating a new record in the Production table. I do not see away to designate my lookup Job Number in Production as 'no duplicates'. I know there has to be away to resolve this. Thanks.