Populating a table based on data from another table

[Jexter]

I am creating a member database. Each record will have a uniquie id number.
I'd like to create other tables to track activity history for each member
while ensuring the information in the activity tables link back to the master
member table.

For example, if a person attends an event or serves as treasurer, I want to
go into the master member table to find that person, but then have the event
or volunteer info appear in another table.

Does that make sense?

 

[Dirk Goldgar]

I am creating a member database. Each record will have a uniquie id number.
I'd like to create other tables to track activity history for each member
while ensuring the information in the activity tables link back to the
master
member table.

For example, if a person attends an event or serves as treasurer, I want
to
go into the master member table to find that person, but then have the
event
or volunteer info appear in another table.

Does that make sense?

This would normally be done with a main form/subform arrangement. The main
form would be based on the member table, and there might be several
different subforms on the main form, each based on one of the related
tables. The subforms would be linked to the main form by the member ID
specificied as the linking field in the Link Master Fields and Link Child
Fields properties of the subform controls.