Search results

Hey All. Me Again. EveryThing seems to working well thanks. Now can someone tell me how I can use insert into that I would tie to a button I have the following mysql="Insert Into EmpJobHistoryTable (EmpID, OldJobId, NewJobId, DateOfChange) Values (" & Me!Text10 & "," & Me!Text12 & "," &...

Me Again. Ok it works so far, however I have 47 skills so far. How can I make sure that i don't type the same skill twice? in other words since the skills are really one-to-one i don't want to have let say AssemblySkill recorded twice. I would need some kind of check to see if I already have a...

Thank you guys for the info. I'm off to build new database based on your suggestion. If I get stuck i'll post it again. Thank you. Rip

Thanks for your reply. I did that before. When I had 2 separate tables i had to create 47 records for each employee. We have about 550 employees. Each Skill also has three values like 1 no experience 2 competent and 3 certified. Those tables were one-to-one relationship. It was simpler just to...

Hello. Currently i'm working on a database that has employeetable. It has the usual like first name , last name and it also has about 38 fields that are skills for that employee like firstaid, assemblyskills and so on. I know that we will be adding new skills in the future. Since those aren't...