I have 4 hierarchical tables and want to display it all together as a form and 3 subforms, when subform displays (and allow to add/edit) only relevant items from each superior subform.
Tables are:
Clients --> linked thru id_client --> Orders --> linked thru id_order --> Licences --> linked thru id_licence --> Regkeys
Access' Form Wizard allows only form + 2 subforms. I tried to create last subform and its link manually, but I'm not successful.
2nd subform (Orders) is linked by:
Link Child Fields: id_client
Link Master Fields: id_client
3rd subform (Licences) is linked by
Link Child Fields: id_order
Link Master Fields: [order Subform].Form![id_order]
which is generated by Access and works satisfyingly. I tried to link last subform (Regkeys) analogically as:
Link Child Fields: id_licence
Link Master Fields: [licence Subform].Form![id_licence]
but it doesn't work and all records are displayed instead of relevant.
Only solution that works is to use subform which is form with 2 subforms, but I'd like other solution.
Any advices? Thanks ahead.
--
version: MS Access 2003 Czech (so I hope to use correct terms)