They appear to be although as I said, I prefer AutoNumber PK's. Numbers sort and index better and the AutoNumber just takes care of itself with no help from me. You can still have the text InvoiceNumber field but it need not be the PK.
Administrator
Windows 7 64bit 
Access 2010 32bit
They appear to be although as I said, I prefer AutoNumber PK's. Numbers sort and index better and the AutoNumber just takes care of itself with no help from me. You can still have the text InvoiceNumber field but it need not be the PK.
Expert
Windows XP Access 2007
The reason I did it this way is because the invoice is unique in the invoice table bacause it can have only one invoice # to many tracking#s. I already have trackingid autonumber in the shipment table but i didn't put one in the invoice table. If I add invoice id and make it autonumber and primary then should I add the invoice# field to the shipment table and use this field to show the relationship between the two tables?
Administrator
Windows 7 64bit Access 2010 32bit
You can put a unique index on *any* field in the table. Your NATURAL Primary Key if fine the way it is here, I was just showing my preference.
Data entry subform: how to add a field in the record but not on subform
Using a listbox on a subform to select subform record.
Write Code to Navigate from Subform to Subform
refresh a subform while not losing focus in another subform
Posting Permissions
Reply With Quote