I have a navigation for with a client tab and a job tab which correspond to a client table and a job table. There is a look-up to to create a 1 to many relationship between clients and jobs.
My form has a 2 column combo box at the top that lists all active clients/jobs. I would like that combobox to filter the client tab for the information of the client selected and the job tab for the corresponding job selected (second column of the combobox).
I a novice at this but I know I need to ignore what I know about VB and work withing the confines of macros so that I can use the database on our sharepoint site.
Your help is appreciated,
Michael