Searching value within specific field (URGENT Help needed)

[BHarries]

Any way you can change the structure to be 2 tables say Employee and Competency?
Employee would have EmpID, EmpName
Competency would have CompetencyID, EmpID, Competency, Rating
1, 1001, Friendly, 3
2, 1006, Smart, 4
3, 1001, Smart, 2
etc,

You would link the tables on EmpID. This way you just have to search 2 fields (Competency and Rating) to find your records instead of having to deal with 200+ fields.

I'm working on access again today and can't get anywhere, I've linked 2 tables together as you said but how can I search for a value in a specific field please?

[orange]

Here is a draft model for consideration. I think you would probably include a CompetencyDate in the EmployeeHasCompetencyAndRating table (for history/progress etc).
You know your environment and requirements better than readers.
Good luck.

[Bulzie]

So what data structure(tables) did you go with? If you have to keep the 200+ tables I wish you luck.