Mutiple subdatasheets

[JHB]

Here is the screen shot for JHB

Yes I see, see.
I get the same as you, if I set the focus back to the table in the navigation window after I've open the table in design view.
After the table is open in design view, mark one of the field names in the table, (because I can see you haven't done that), then it should be there.

 

[MPater]

Still no cigar. I get a variety of items listed, depending on the data type of the field concerned. For example, for the primary key I get the items listed in Post no 7. None of the property sheets list the Subdatasheet name, as in your post no 6.

 

[JHB]

Last try, open the form in the attached database and click the button.
When the table open, right click and choose "Properties".
Evidently it is possible to hide/ prevent property sheet from appearing. The inserted link gives a detailed description of the problem in post #6.
http://www.access-programmers.co.uk/forums/showthread.php?t=136432

 

[ions]

MPater it is in the General Tab. There is a property / field called SubDatasheet Name. In this field you select the child table.

Ooops I didn't realize this thread had 2 pages. It looks like you found it.

 

[MPater]

ions: unfortunately it, whatever you mean by "it", is not in the general tab. See the screenshot in post no 18 in this thread.

 

[MPater]

ions: continuing - I haven't found it.

 

[ions]

Interesting. I looks like that / your screenshot is from Access 2013. "It" was referring to the SubDatasheet property. SubDatasheet is present in the General Tab in 2007. I presume this has been removed from 2013? Strange.

 

[MPater]

ions - I have Access 2010, up-graded from 2007. The mystery thickens

 

[ions]

Try this. Look at Page 100

http://books.google.ca/books?id=YWz...v=onepage&q=Access 2010 SubDatasheets&f=false

 

[MPater]

ions: thanks for the suggestion, but it does not cover the situation where several child tables are linked to the parent table by the same key. Because I cannot find the property sheet for the parent, I appear to be permitted to open only one of the subdatasheets.

 

[ions]

My understanding is that at the table level you can only link one child table to the parent table.

What you can do is create multiple forms with SubDatasheets.

Below is an example of SubDataSheets in forms. You can make several of these forms and link them to different child tables achieving the result you are after.

https://www.youtube.com/watch?v=gfly_K78reA

See this link for instructions on how to make Subdatasheets in forms.

http://bytes.com/topic/access/answers/204346-subdatasheets-how-use-subform

 

[ions]

I just thought of something else that may be easier.

From the above second URL I gave you it appears that you can make SubDatasheets with Queries as well. I didn't know this.

If you can create SubDataSheets with Queries (I am not certain as I have never done this, I typically create SubDatasheets on forms) just make multiple queries with all the records from the parent table and then link the different child tables at the query level.