Data Sharing within Tables?

[clai]

Hi,

i was excited to find a forum where i could ask a question regarding access! thanks in advance for the help:



i'm trying to design a database for a series of conferences my office will be having. i'd like to have a table into which all the names of all contacts for the entire program are entered. i'd then like to have three additional tables for the individual conferences within the program that would take all the information from the main table on the participants and reflect it identically in each of the additional tables. so some of the names from the main table will be in each of the conference tables, but not all. just those associated with teh specific conferences. could someone tell me how to get a table to pull data from another table within excell? or is there some other way to acomplish what it is i'm trying to do?

thanks agian.

[NTC]

well that is not normalized.

TableNames has names of all attendees - and assign a unique ID to each using autonumber field

Then in TableConf1 - you just put in their unique ID

If you need to display their name info in a form or report - join the tables in your underlying query.