Posted on 2014-10-27
I have the following table structures:
Cartons: CartonID (autoID), TrackingNumber, RANumber, DateReceived, etc...
CartonContents: ContentID (autoID), CartonID, etc...
RANumber, and sometimes even TrackingNumbers can be found on several cartons. In other words, records in table Cartons can look identical.
When it comes time to enter the contents, staff pull the boxes, several staff at the same time working the same batch of cartons. I was planning on having them select a carton record and start entering the content data. Then I thought it may be safer to have an unbound form that when clicking 'Add' it grabs an available CartonID. The thing I need to guarantee about is that two staff don't try and use the same CartonID at the same time but either method seems it could be possible for users to 'clash'