Hi I'm operating on a pretty basic level with access and have just started using ID fields as foreign keys to join tables. Given the following example:
tblInventory has two columns InvName and InvID
tblSupplier has two columns SupName and SupID
I could join these in two ways:
1) Add a field to tblInventory called SupID and Join it with tblSupplier!SupID
2) Add a field to tblSupplier called InvID and Join it with tblInventory!InvID
I'm wondering what criteria one would use determine which would be the best way?
Thanks in advance for any comments.
tblInventory has two columns InvName and InvID
tblSupplier has two columns SupName and SupID
I could join these in two ways:
1) Add a field to tblInventory called SupID and Join it with tblSupplier!SupID
2) Add a field to tblSupplier called InvID and Join it with tblInventory!InvID
I'm wondering what criteria one would use determine which would be the best way?
Thanks in advance for any comments.