SubDatasheet Problem

[JAD]

SUBDATASHEET Problem

I am having a problem trying to use the subdatasheets. I have 5 tables, Master and Tbl1,2,3,4. I have set up the relationships of the so they have a 1-1 relationship with the master. I am assuming that with the subdatasheets you should be able to look at the master and click the + to open each table that is referenced. Is that true? I can only seem to get it to open 1 other table. Also in looking at a diagram for setting up datasheets from a MS Access 2000 Bible the Table properties box looks completly different than the one I have. There should be a Subdatasheet Name line which I can set to auto but mine doesnot have that. There are also other lines missing. I do have Access 2000. Any ideas?
Thanks!
JAD

 

[llkhoutx]

Check you relationships window and link your tables, if they're nor already linked.

 

[JAD]

All tables are linked with a 1-1 relationship....

 

[llkhoutx]

Are they linked in the relationship window?

 

[JAD]

Yes

 

[JAD]

subdatasheets

O'h well I guess no one can solve this problem...

 

[neileg]

Subdatasheets are relatively new in Access. If you add to that the fact that tables are places to store data, forms and reports are places to display data, you will understand that most people simply don't use subdatasheets, and so have no view on what your problem is.

 

[JAD]

Problem Solved-
I was Assuming the sub data sheets had to be set up at the same time but I found out that it will only do one then you have to set up the relation to the next one ....

 

[AnnPhil]

I have a form that uses subdatasheets also and it was working fine until today. When i open the form the + is gone and so i can not view the subdatasheet. I know i have several records but do not know why it worked yesterday and doesn't today. Has this happen to you? Do you know of a fix?

when i open the subform with the sudatasheeet by itself i can see the +. When i open the main form that has the subform with the subdatasheet it is missiing?!?!?!?!? Also, the tables have the + and can be seen.