I have setup a data base and from reading and feedback on forums. My design is not great and causing me some greif. I have five tables and U want to get join then for certain query. I read that I should creat an assocate table which had the PK for each table in it.
The part that I'm having a hard time understanding is how to populate the PKs in the assocate table as FK.
Once this s done, how would I use the associate table to pull the information out of the tables
any help or times is great.
[u] children[/u] child_id(pk) childfirstname childlastname childdob [u]sibling[/u] sibling_id(pk) sibfirstname siblastname [u] spouse[/u] spouse_id(pk) spousefirstname spouselastname [u]users[/u] user_id(pk) userfirstname userlastname username associate table [i]aboutMe[/i] aboutme_id(pk) child_id(fk) spouse_id(fk) sibling_id(fk)