Combo Box

M

Melissa

Hi

I have a form for "Clients' which has a subform "Vehicles" to view all
vehicles for a specific client (this is a windscreen repair company
database)

I also have a form for "Companies" with a subform also for "vehicles"

then i have another form "Jobs" where I select the client from a drop down
list and the that clients VehicleReg is selected from another combo box,
which then populates the "make" and "model" fields automatically on this job
form

Now, I would like to create a combo box to go onto the "jobs" form in which
I select a Company (from the CompanyTAble), then i would like the
"contactPerson" for the selected company to also appear in the "Clients"
combo box along with all the client...is that possible? Also when i select
a "company" on the jobs form, and then the "contactperson" in the clients
drop down, I would like the "Companies" vehicle registration detaills to
also appear in the same VehicleReg drop down all the "Client's"
VehicleReg's

Please help

thank you kindly

Melissa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top