Hello,
i have simple database that uses an employee table. on a form i have a drop down to select an employee name, all works good
i added an employed column with yes/no option for the employee list so only current employees show up on the drop down
i filter this with a query to make a list of only current employees
once an employee is not employed he/she is removed from the query and drop down just like wanted, but problem is if i look at old forms it wont display the old employee, (the index to the lookup table is there)
basically the drop down needs to display data from query, but once selected the data needs to come from the table
how can i get this to work?
thanks,
d
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar