Nested tables/drill down limitations...?

[connexion]

Hi there,

I'm using access 2000 for starters.

I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data form to work with.

However i have found that tables 1 through 7 are visible, but access doens't give a little "+" in the corner of table 8 to get to tables 9 and 10. i.e, i can't seem can't seem to drill down beyond table 8 to view related records in tables 9 then 10.

Does this mean that there is a limit to how far you can drill down through table relationships within access?

Thanks
Vince

 

[andrew93]

Yes the limit is 7. See the 'Form and report' section of this webpage
Andrew

 

[connexion]

Hi Andrew,

Further down in my posts you'll see that i did eventually find the answer to this one, in the access helpfile itself of all places! (i know! strange but true, a help filed helped me for a change instead of sending me on a wild goose chace!)

I can understand that nesting tables/data within a form or report might get somewhat complicated for access to deal with, however i would have expected this limitation to be increased if working purely with tables in the database window as nothing other than straight forward table relationships is involved.

Thanks for your input however, it's all appreciated.

Vince