Help with Table Structure
Posted: Tue Mar 24, 2009 7:24 am
Hi Guys
I have been having some serious trouble getting the information I want, and Have taken the advise to restructure my tables. I have attached the Old Structure and the new one.
I was just after some constructive advise on whether the new one is better and if it will help me get the info i want, which is:
I want to display a table with the following colums
Required Skill (comes from ID_Table) Weight (Comes from ID_Table) Score (Comes from Person_Skill)
does this make sense?
Thanks in advance
I have been having some serious trouble getting the information I want, and Have taken the advise to restructure my tables. I have attached the Old Structure and the new one.
I was just after some constructive advise on whether the new one is better and if it will help me get the info i want, which is:
I want to display a table with the following colums
Required Skill (comes from ID_Table) Weight (Comes from ID_Table) Score (Comes from Person_Skill)
does this make sense?
Thanks in advance