I have a form that is used to add new parts to my products table.
The fields are
Part number
Description
Location
Supplier
Cost
When I open the form it goes to a new record that I can add a new part.
all good
The problem is that I can type a duplicate part number that is already in my products table.
The Part Number field in my table is set to no duplicates so I do not know that it is a duplicate until I go to safe the record.
I have tried refresh the form after entering this value but i get a new blank form to enter date.I think I need to use a validation rule is this correct. If so what would it look like
The fields are
Part number
Description
Location
Supplier
Cost
When I open the form it goes to a new record that I can add a new part.
all good
The problem is that I can type a duplicate part number that is already in my products table.
The Part Number field in my table is set to no duplicates so I do not know that it is a duplicate until I go to safe the record.
I have tried refresh the form after entering this value but i get a new blank form to enter date.I think I need to use a validation rule is this correct. If so what would it look like