What I am wanting to do seems very simple but due to my lack of experience I must be missing some basic understanding, please help.
So I have a job list table:
job number (primary key),
I then have a fees list table:
fee ID (primary key)
So I want to create a form, so when a new fee instruction is confirmed the user can insert or select the job number in the form, which will then pull data from table 1 (site name and client name), and insert all three bits of information into the form (job number, site name and client name), which the user can then add the information for the department, service and fee sections, and it all gets saved to table 2.
I have been trying to do this without a sub form. I have been using a list box which allows selection of only job numbers in table 1, however once that is selected, I obviously want the corresponding site and client names based on that job number to be inserted. This is to remove human error from the user being able to put wrong site and client names to job numbers.
For example is it possible to filter listbox 2 and 3 based on the selection in list box 1??
Thanks in advance