Recent content by WolfwoodZero

Ok, i've set up the above tables. Looks good, very few fields etc.. However, i need this be completed by a user and had designed a form with all the skills listed as tick boxes which just saved a Yes/No for each skill. Setting my tables out this way means all the skills are records not fields...

Thanks everyone, i'll try the above suggestions and attempt to improve my understanding a bit. Happy New Year

But does that not mean i will have to update both tables STAFF ID's everytime someone joins or leaves the company and make sure the are exactly the same? Thats like 1000 ID's to keep checkin. If so, theres no point even making a 1-2-1 relationship, i may as well have 2 stand alone tables? I'm...

Hi, I'm afraid I am unable to be overly technical with my question as i've only really had a 2 day access course, sorry in advance!!! Problem I am trying to create a skills Matrix, it will need to include approximately 400 different skills which a staff member my or may not be trained on. I...