Partically Linked Data

[Guest]

I have a table but want a second (sub) table with some of the data. I need
the shared data to be changed in both tables when one is influenced, and I
need the second table to have fields the master table does not.

How do I do this? is it some sort of query because the make-table query
won't allow me to add extra fields . . .

(example of MASTER TABLE: Field 1: Names, Field 2: Yes/No Event, Field 3:
yes/no event)
(example of SECOND table: Field 1: Names check off in Master's Field 2 only,
Field 2: birthday)

can I do such a thing? please help. I'm new.

 

[Guest]

Manually create the "sub" table. Have a primary key for the main table and
a foreign key in the "sub" table. Best to use an autonumber for the primary
and then a number-integer for the foreign key.

 

[Guest]

The data type should be Long. Autonumber fields are Long.