Enqiry regarding selected data in combo box

[nrmarthi]

hello everyone

i created 4 tables

Departments (DepartmentName as prime key),
Employees (EmployeeCode as prime key, as prime key field can't have duplicates as it occuring in case of EmployeeName),
ErrorReference (ErrorCode as prime key) and ErrorCategory

I built onemore table "Performance", in which 'workOrderRef, Date, Cost and WorkOrderPic' are local fields and rest of fields (departmentName, EmployeeCode, EmployeeName, ErrorCode, ErrorRef) are linked to different database to prop up data while data entry.

Also did relations between these tables in order to facilitate cascading effect of modification in respective database bases.

Now the question is - in input database file i.e. "Performance",
- when i prop up "CAD" department, i should get employees in CAD department and in turn employee code.

similarly

- when i prop up any Error rerefernce, it should automatically prop up corresponding ErrorCode

can anyone tell me how to se filter command?

Thank you
Rao

 

[nrmarthi]

Guys plzz help me

i posted above query, so if anyone of u have clue, plzzz reply me.

Thank you

 

[neileg]

I think what you want is cascading combos. Do a search on that subject.