| re: form design one to one relation
On Tue, 14 Dec 2004 10:56:15 +0400, "Burghew" <burghew@mailinator.com>
wrote:
[color=blue]
>My relationships are as follows:
>tblworkorders1---m tblWorkOrderDetails ...M----1
>tblServiceTypes...1...1..ServicetypeA...differe nt 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.
>
>
>--
>'Thanks & Regards'
>
>[/color]
Hi
You imply you have a fixed set of servicetype subforms.
You could put the different subforms on different pages of a tab
control and replace the combo box by selecting the tab.
David
| 
