multiple entries for a search field?

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

I have an access database with a name field. Is there a way to set it up so
I have multiple names for the same database record.

Its simply a name and multiple stage names?
 
Storing multiple values in a single field is actually a violation of
relational database theory.

If you have multiple names that you need to associated with a specific
record, you should add a second table with one row for each name, with a
foreign key on each row pointing back to the record in your original table.
 
I have it set up now with three extra name fields.

I have them in the original database.

How do I do it if I have to have an unknown number of names?

Thanks
T
 
I think you missed the point of what I was saying. You shouldn't be setting
up 3 name fields. Your new table should have 1 name field. If you have 3
names to add, you add 3 rows to that new table.
 
Back
Top