Colin Mckinney
|
| Posted: 07/01/2004, 8:08 PM |
|
I have several similar tables where different departments use different data - Dept A may need to fill in Employee, Function, etc and Dept B does the same but they need to only see a drop down pertaining to their department.
I created the employee table with userID, deptID, etc. and added deptID to the Function table as well - so that based on login the users department ID will only show corresponding Function items that relate to their department.
Do I set the properties of the list box to do this - or is this an event custom code?
Also - and this may be a dumb ?? If I make relationships (one - to - many, etc) within codecharge - does that effect only the field or event I am working on or does it effect the access dbase as well - (create relationships)?
And....if it would help to solve this over a 2-hour cruise on a luxury Sea Ray - Ill supply the laptop and the Sea Ray - you just make it down to Florida....
|
