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

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"
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top