fester62
asked on
Can I have a sub-sub-form in Acess 2003
Can you have a Sub-form within a Sub-form in Acess 2003 ? Microsoft says you can nest up to 7 levels(although that may be just in 2007). When I try this it wont allow a continuous form to be embedded on another continuous form (which makes sense, but what are the mechanics of achieving sub-sub- forms in that case?)
Tony
Tony
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use forms in Datasheet view to do this, if they will suit your needs.
I should clarify: Using forms in Datasheet view in this manner will provide you with an interface similar to the "SubDatasheets" feature in 2003+ ... this may or may not work for you.
ASKER
ok, thanks I thought as much.
Tony
Tony
ASKER
LSMConsulting: How do you link the Sub-datasheet ? Can that be used on a contiuous form ?
Thanks.
Tony
Thanks.
Tony
ASKER
LSMC: I dont think you can show a Sub-datasheet on a contiuous form, even if the contiuous form is in datasheet view. At least I couldnt get it to work.
Tony
Tony
Hi fester for sub datasheets to work the tables have to be linked in the relationships window and have referential integrity enforced
In 2003 you can have a sub-sub-sub-sub-sub-sub-fo rm. :-)
(7 levels deep).
However - as mentioned several times now - continuous forms won't cut it. And would be a tricky UI due to their rigid nature - hence why it's makes more sense in datasheet view).
Access 2000 introduced subdatasheets.
There's no requirement that the datasheet form sourcess be specified at the relationship level. Created as standard linked parent and child subform will create the desired form UI result. (Master Child link fields).
(Establishing the relationship will help Access offer such a display through the table datasheets - where the SubDatasheet property allows the desired table to be specified. But it's just inappropriate functionality for application release of course).
(7 levels deep).
However - as mentioned several times now - continuous forms won't cut it. And would be a tricky UI due to their rigid nature - hence why it's makes more sense in datasheet view).
Access 2000 introduced subdatasheets.
There's no requirement that the datasheet form sourcess be specified at the relationship level. Created as standard linked parent and child subform will create the desired form UI result. (Master Child link fields).
(Establishing the relationship will help Access offer such a display through the table datasheets - where the SubDatasheet property allows the desired table to be specified. But it's just inappropriate functionality for application release of course).
<for sub datasheets to work the tables have to be linked in the relationships window and have referential integrity enforced>
I wasn't really referring to actual SubDatasheets, but rather using Forms in Datasheet view to mimic the look and feel of SubDatasheets. As Leigh said, the only thing you need for the Form method to work is to correctly link your forms (i.e. Master/Child links).
You can't make this work with Continuous view forms ... you must use Forms in Datasheet view.
I wasn't really referring to actual SubDatasheets, but rather using Forms in Datasheet view to mimic the look and feel of SubDatasheets. As Leigh said, the only thing you need for the Form method to work is to correctly link your forms (i.e. Master/Child links).
You can't make this work with Continuous view forms ... you must use Forms in Datasheet view.