M
Mike Diamond
I am building a service request database which logs a fault taken by a
customer. Now because each customer will have many contacts, i want to create
a form where a list of contacts can be selected or automatically added using
a combo, when the relevant comany is selected in another combo.
At the moment i have a seperate table for service details, customers and
contacts but dont know how to join the relationships or how to create the
combo boxes to show this information. Can anyone help at all? I also
appreciate that this is going to be a lengthy and detailed explanation ...
customer. Now because each customer will have many contacts, i want to create
a form where a list of contacts can be selected or automatically added using
a combo, when the relevant comany is selected in another combo.
At the moment i have a seperate table for service details, customers and
contacts but dont know how to join the relationships or how to create the
combo boxes to show this information. Can anyone help at all? I also
appreciate that this is going to be a lengthy and detailed explanation ...