form design one to one

B

Burghew

My relationships are as follows:
tblworkorders1---m tblWorkOrderDetails ...M----1
tblServiceTypes...1...1..ServicetypeA...different fields
Also tblServiceTypes...1...1 ServicetypeB..diff fields.
I have a combo Select servicetype in the main form frmWorkOrder with
sbfWorkOrderDetail as subform which has a list of the service types
namely servicetypeA and ServicetypeB when The user selects ServiceTypeA the
form should open up with the frmServicetypeA fields and when the user
selects servicetypeB the form opened must be frmservicetypeB. Please advice
the best method to get this done or if ther is any other work arounds for
the same.
Hope I have made myself clear.
 
Top