Linked Tables

[CEB]

Hi folks,
I have a table and I want most of the fields available to others. I also want the other users to be able to add fields to the table (not the master but theirs). Here's an example to explain it better:

MasterTable contains the following fields:
Name,Address,Phone,Training,Checks.

I want the Users to have a linked table with access to:
Name,Address,Phone

I also want the users to be able to add their own fields like:
Date of Birth etc. to have a table that is linked to Master but they can change some fields.

Any suggestion would be much appreciated.
Thanks,
Colin.

 

[CEB]

Thanks alot Pat,
I'll have to think about this further. Adding extra fields for the other users is definitely a way to go. Is there a way that they can only see what fields I wish them to see or do I have to break the table into seperate tables? I have already a lot of records in there and there is no primary key. I could give all the records unique numbers if I have to split it in to different tables though.
Thanks again,
COlin