K
Ken
Main
ID
First Name
Last Name
etc
People
BioID
BirthDate
DeathDate
The two have a one to many relationship and I have a form that uses
both tables. When I create a new record it uses the Main Name fields.
And a corresponding record is create for People based on the
ID<=>BioID relationship. Unfortunately, I get duplicate names in Main
and duplicate records in Bio.
Unfortunately I got it backwards as I should have the First and Last
Name only one time in People to be a one to many in Main. (i.e. The
Main table would have multiple occurences using the name.)
Here is what I want to do:
Have People table to only have unique records-one per name (First Name
and Last Name key?)
What would constitute the relationship since the People table key
would be based on two fields? Or should it? I need help with what each
table's key should be.
How can I restructure the database? How can I get the name fields to
be only one time in People? I can run a query to show ID, BioID and
the name fields together but how can I add or append the names to the
People table?
Should I save the Main table to another name (People1) and then delete
all fields but the name fields. Then go in and delete the duplicates
and set the key to no dupes based on first and last name fields? I
have about 500 records.
All of my queries and most forms use the Main First and Last Name
fields so I would need to revise them.
ID
First Name
Last Name
etc
People
BioID
BirthDate
DeathDate
The two have a one to many relationship and I have a form that uses
both tables. When I create a new record it uses the Main Name fields.
And a corresponding record is create for People based on the
ID<=>BioID relationship. Unfortunately, I get duplicate names in Main
and duplicate records in Bio.
Unfortunately I got it backwards as I should have the First and Last
Name only one time in People to be a one to many in Main. (i.e. The
Main table would have multiple occurences using the name.)
Here is what I want to do:
Have People table to only have unique records-one per name (First Name
and Last Name key?)
What would constitute the relationship since the People table key
would be based on two fields? Or should it? I need help with what each
table's key should be.
How can I restructure the database? How can I get the name fields to
be only one time in People? I can run a query to show ID, BioID and
the name fields together but how can I add or append the names to the
People table?
Should I save the Main table to another name (People1) and then delete
all fields but the name fields. Then go in and delete the duplicates
and set the key to no dupes based on first and last name fields? I
have about 500 records.
All of my queries and most forms use the Main First and Last Name
fields so I would need to revise them.