Why: So that I can reuse tables, such as addresses, phone numbers, email, etc.
How can I do it?
Currently I have a Licenses table that has an autonumber PK, and that PK is the FK in many of the noncore subtables such as the ones above.
Now I want to create another table for Permits, and I want to reuse some of the noncore tables to save space and make coding far easier and less complicated. What is the best way to do it?
I was thinking of a one or two letter prefix on the PK, such as
L1234 for a license PK and P1234 for a permit foreign key, this way I could use the SAME FK column in those noncore subtables.
1. Could I Concatenate a text and autonumber?
2. Or should i use two columns as the PK, but wouldnt this make coding for Forms, Reports, and Queries crazy complicated?
Any other ideas?
How can I do it?
Currently I have a Licenses table that has an autonumber PK, and that PK is the FK in many of the noncore subtables such as the ones above.
Now I want to create another table for Permits, and I want to reuse some of the noncore tables to save space and make coding far easier and less complicated. What is the best way to do it?
I was thinking of a one or two letter prefix on the PK, such as
L1234 for a license PK and P1234 for a permit foreign key, this way I could use the SAME FK column in those noncore subtables.
1. Could I Concatenate a text and autonumber?
2. Or should i use two columns as the PK, but wouldnt this make coding for Forms, Reports, and Queries crazy complicated?
Any other ideas?
