October 15, 2004 at 11:49 pm
I have employee table that has Name, EmpID and IsCurrent.
The IsCurrent is a flag for current employees.
I have an order form and a lookup function that displays the current employees. The user picks the Employee and the EmpID is stored when the form is saved.
Tomorrow, the employee is no longer current and when you bring up the same order form, the employee name no longer shows because the lookup fails with empID that no longer isCurrent.
If I save the Emp Name in the order form, the problem is resolved. However, I have just De-normalized my order table.
What is the correct way to handle this problem?
Thanks
October 16, 2004 at 6:35 am
You need 2 lookup's. One to display all employees when showing the form, and another which is restricted by is current for when the user picks one.
You could also have just one function but display non current users in gray - then if a user picks one use validation either on the form or in the database to generate an error something like "This employee is no longer current" The users should figure out quite quickly that the gray ones are not valid.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply