spalmateer
Registered User.
- Local time
- Today, 19:39
- Joined
- Dec 5, 2000
- Messages
- 46
Hello,
I need to find a work around to this problem. In my database I have a field in my employee table that marks an employee either active or non-active. Then on the form I use a query to filter the selection so only active employees can be chosen from the combobox. The problem is when an employee is selected as inactive, the data disappears in the form. For example, if I enter John Doe into the database as being the salesperson for an order, then 10 months down the road he quits. I mark him as inactive but whenever I view that old order in the form, the salesperson data has disappeared. However, when I look in the table its still there. I guess what's happening is that if the employee ID cannot be chosen in the combobox (from query), then the old data will not be shown. Any way around this? I want to limit new entry to only active employees, but I still want to show old inactive employees if they've already been entered. Thanks in advance for any help/ideas!
Scott
I need to find a work around to this problem. In my database I have a field in my employee table that marks an employee either active or non-active. Then on the form I use a query to filter the selection so only active employees can be chosen from the combobox. The problem is when an employee is selected as inactive, the data disappears in the form. For example, if I enter John Doe into the database as being the salesperson for an order, then 10 months down the road he quits. I mark him as inactive but whenever I view that old order in the form, the salesperson data has disappeared. However, when I look in the table its still there. I guess what's happening is that if the employee ID cannot be chosen in the combobox (from query), then the old data will not be shown. Any way around this? I want to limit new entry to only active employees, but I still want to show old inactive employees if they've already been entered. Thanks in advance for any help/ideas!
Scott