Hi,

I have two records in the same table for separate individuals.

I want to create another table to hold  different data for only one of the individuals from the first table.

Is it possible to use the table relationships I learnt in Expert 1 to take just the name of the individual from the first table to avoid duplication of the name?

Thanks,

---

Reply from Alex Hedley:

You can do it that way, you could have a NameT that has NameID and Name
1 | Fred
2 | Jane

Then a UserT
UserID | NameID | OtherInfo
1 | 1 | Likes Cheese

Then you can create a Query that joins UserT NameID with NameT NameID to show the name of User 1.