Table Design - Multiple Fields

[ellford]

I'm hoping someone can help me with this one. I have a database that tracks seminars and registrations. I need to revise it as they want to allow an individual to add in up to 10 more additional people on their registration.

The simple way would be to do the following (you'll see my 10 additional fields in here), but I don't think this is the 'RIGHT' way:

Tbl_New_Registrations
Registration_Number - Autonumber - PK
Seminar_Name - Lookup (goes to Tbl_Seminars)
First_Name - Text
Last_Name - Text
Business_Name - Text
Years_in_Business - Number
Address - Text
City - Text
State - Text
Zip - Text
Phone - Text
E_Mail - Text
Questions - Memo
Additional_Registrant1 - Text
Additional_Registrant2 - Text
Additional_Registrant3 - Text
Additional_Registrant4 - Text
Additional_Registrant5 - Text
Additional_Registrant6 - Text
Additional_Registrant7 - Text
Additional_Registrant8 - Text
Additional_Registrant9 - Text
Additional_Registrant10 - Text

What I 'think' is required is an Additional_Registrants table, but I'm not sure how to do this so that when someone fills out a registration form, the 10 additional registrants go into this table and the database knows that these 10 belong to record X and so forth.

Does this make sense?

Any ideas or thoughts on this on?

 

[Newman]

Create an «Additional_Registrant» table that contains these three fields:
Additional_Registrant_Number - Autonumber - PK
Registration_Number - Number - FK (FK=Foreign Key)
Additional_Registrant - Text

Then join the «Registration_Number - PK» with the «Registration_Number - FK»