how to display one to one relation data on a form.

B

Burghew

Hi all,
I have a form which is used to enter workorder details. Now for the service
types I have a one to one relationship with the different services
available. Each Work order detail may have many services (of differnt types
with differnt field values). I need the WorkOrderDetails form to display a
combo from which the user can select the service type and based on this
selection show the appropriate form (eg: frmPlumbing when service type is
plumbing, frmengineering when service=engineering, frmcooking when
service=cooking). Please help.
TIA
 
Top