Sub-table with linked info and then some

[Guest]

I have a master table with a list of people. These people register for our
different events. I have a yes/no field for each event, so I can do a query
sort. However I need subtables (one for each field/event). When I create a
"make-table quesry" I can't add additional fields to this second table which
are not in the master table.

Also, I need these two tables linked, so that when a new person registers,
on the master table I can check the event box and have them appear on the
second table/query/form . . .

What are my options? Do I even start at this from the query route? Can
anyone please help me?

 

[Guest]

Your table structure is wrong. You are using it like a spreadsheet. You
need a table for people with their information. You need a table of events.
Both of these table to have an autonumber field as primary key.
Then a third table with number-integer fields to contain foreign keys to
match the people and event primary keys.
Create a relationship of one-to-many from the people to third table. Also
create a relationship of one-to-many from the event to third table.
You can add other fields to the third table like EventDate, Cost, Paid,
Confirmed, etc.
Use the people and third table in form/subform and listbox with the event
table as source in the subform.

 

[Guest]

okay i'll give that a try. Thanks for your help!

Your table structure is wrong. You are using it like a spreadsheet. You
need a table for people with their information. You need a table of events.
Both of these table to have an autonumber field as primary key.
Then a third table with number-integer fields to contain foreign keys to
match the people and event primary keys.
Create a relationship of one-to-many from the people to third table. Also
create a relationship of one-to-many from the event to third table.
You can add other fields to the third table like EventDate, Cost, Paid,
Confirmed, etc.
Use the people and third table in form/subform and listbox with the event
table as source in the subform.