By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Table layout for items on a pallet

aas4mis
P: 97
I've been out of the access game for a while and was curious what the best table/relationship layout would be for keeping track of items on pallets.

I've got a manifest consisting of name, store, order, and tracking number. I would like to be able to scan a 'start' barcode, scan multiple tracking numbers to a pallet, then scan an end barcode. All items should then associate to a pallet via the unique tracking number so I can later print an end cap to attatch to the pallet before it's shrink wrapped.

Any suggestions on this fairly simple table/relationship layout would be appreciated.

Thanks!
Feb 18 '10 #1
Share this Question
Share on Google+
4 Replies


aas4mis
P: 97
With this database being so small it might make sense to use a natural PK based off of the tracking number, but I'd like to avoid that (preference). Please suggest a layout which implements surrogate PK's.

Thanks!
Feb 18 '10 #2

nico5038
Expert 2.5K+
P: 3,072
Obviously using an autonumber with +1 increment is the fastest way, but what about recording the barcode and a date/time stamp ?

Nic;o)
Feb 19 '10 #3

aas4mis
P: 97
I can work out the forms details later (barcode start/stop), I'm just looking for a good base to start with. An ERD if you will. All the manifest info will be imported into 1 table and Pallet info to another table. Not sure the best way to relate the two and what fields to use in the pallet table. I'm sure I'm oversimplifying, should there be a join table? So many ways to organize such simple thoughts, looking for some insight.
Feb 23 '10 #4

aas4mis
P: 97
As much as I want to avoid it I decided to use a natural key based on the tracking number. After a little thought I realized business rules would not always have the manifest data available before the tracking number would be available, breaking my surrogate key design that I had hoped for.
Feb 24 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.