Linked tables, datasheet view the + plus sign is missing

[kshamloo]

Good morning my Access Guru community:​
I have a parent child relationship between two tables, I get my + sign when I open the parent table in the datasheet view.

However if I split my database to objects and tables and linked the same tables to my new database, the + sign is now longer shown in the datasheet view of the parent table.



even though under relationship button I see all my links intact.

any idea why I'm not seeing the plus + sign in the linked database?



thanks guys

[June7]

Because, AFAIK, simply doesn't work with linked tables. I never design db to depend on Subdatasheet, find it too confusing.

[Perceptus]

make sure the relationships are in the right database. Ive seen where some users make the relationships in the Front End whilst the data is in the backend file.

[June7]

I already had relationships in backend. So tested creating relationship in frontend, still no Subdatasheet.

[davegri]

I get same results as June7 - from a linked BE you don't get the auto link sheet dropdown in the FE.
I never noticed this before as I never use tables in that manner.

[isladogs]

A couple of extra points.
For local tables, you can also add a subdatasheet from the Home tab ... More ... Subdatasheet
However for linked tables that option is disabled - its definitely not possible.

Also, although some people really like subdatasheets, users should not deal with tables directly so therefore that also applies to subdatasheets.
All interaction should be done using forms

[June7]

However, can build a form/subform with the linked tables and with at least main form in Datasheet view and Master/Child Links properties set, the + will be available and Subdatasheet can be opened.

[kshamloo]

June7 you are awesome who ever you are, the way you handle problems is like a text book out of Scientific Methods.
Is only a Hypothesis unless is proven over and over again.

Having said that, I also found another way to solve our problem, once splitting the database between tables and objects, I went to my table side, opened up my parent table, went to its properties, and populated the following:
Subdatasheet Name: this is the name of my child table
Link Child Fields: this is my join field
Link Master Fields: this is my Parent key index to the child table

I deleted all my links from the Objects database, Re-Link back to the newly modified tables and the plus + sign is back in action.

again thanks so much for being relentless on your persuade of the truth and finding a eloquent solutions.

[June7]

Ahh! I seldom set properties in tables so had not been aware of those. Learn something new every day.

But I don't like the Subdatasheet and don't allow users to work directly with tables so wouldn't bother with anyway.

Glad you found satisfactory solution.

[isladogs]

Kshamloo
Are you aware that you can only add a local table as a Subdatasheet using the method you just discovered
You still can't add a linked table as a Subdatasheet.

[kshamloo]

Kshamloo
Are you aware that you can only add a local table as a Subdatasheet using the method you just discovered
You still can't add a linked table as a Subdatasheet.

No, that's a beauty of it, my subdatasheet is linked and not local to the database, as long as altering what I described taking place at the tables side, it works.
thanks for the response though.

[isladogs]

OK fine. Perhaps I didn't follow your instructions fully....
I still wouldn't recommend it for the reasons I stated before - users should never work directly with tables.

Also, if you relink all your tables again using the linked table manager, do you lose your linked table subdatasheets?