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
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