how do I add a field to an existing template in Access 2007

  • Thread starter Thread starter P&F Buderim
  • Start date Start date
P

P&F Buderim

I am establishing a contacts list for a Parents and Friends Association (for
a school). I want to add a "family code" to my list of contacts to make it a
"primary code"
 
You need to create a Family Code table. It probably needs only two fields
FamilyID - AutoNumber, Primary key
FamilyName - Text

Then in your contacts table, add a field of data type Numeric, Long. It can
also be named FamilyID.

In your relations window, relate the contracts table to the family code
table as one to many.
 
Back
Top