I have a table that list a set of numbers in one field, the organization in a field and the position title in a field. The numbers are specific to the organization and the position title.
Number Org Position
89087 Company A Clerk
52145 Company A Mgr
32154 Company B Clerk
12545 Company C Clerk
And so forth – This is a list of numbers that is about 400+
I have created a form that displays the personal information about the employee – Name, Organization, Position title. I have also added a drop down to chose the number. I have created a dropdown to display the number based on a query that will only display numbers not used. I need to narrow this down to display only the unused numbers based on the company and position title of the individual so I do not have to search for the available Company A, Clerk numbers through the whole list.
How do I write the code to open the form, look at the Organization and Position titles fields and determine the correct set of numbers to display in the list?
Number Org Position
89087 Company A Clerk
52145 Company A Mgr
32154 Company B Clerk
12545 Company C Clerk
And so forth – This is a list of numbers that is about 400+
I have created a form that displays the personal information about the employee – Name, Organization, Position title. I have also added a drop down to chose the number. I have created a dropdown to display the number based on a query that will only display numbers not used. I need to narrow this down to display only the unused numbers based on the company and position title of the individual so I do not have to search for the available Company A, Clerk numbers through the whole list.
How do I write the code to open the form, look at the Organization and Position titles fields and determine the correct set of numbers to display in the list?
