Split database relationship tables

[Boon]

Hello

I splitted the database into the front-end and back-end. The back-end
contains tables, and front-end contains the forms and queries.

I have two tables that related to each other. (Relationship). Let's say
that Table A is the mother table and table B is the child table. When I open
table A in the front-end, I couldn't see the plus sign at the first section
of each record. I can see the plus sign when I open the back-end though. Why
I don't see it on the front-end? Am I be able to see it?

thanks,

 

[Jeff Boyce]

Access tables store data. Access forms display data.

Even though Access offered/offers the "+" in tables, you really don't want
(your users) to be working directly in the tables. They make look like
spreadsheets, but they aren't!


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[TedMi]

Reminds me of the old joke:
Patient: "Doc, it hurts when I do this."
Doctor: "Don't do that!"

Granted OP should not depend on opening subdatasheets directly in tables,
but your answer does not address the underlying cause of the anomaly seen by
OP. In my databases, I see the + in both front and back ends.

-TedMi

 

[Jeff Boyce]

(yup, I didn't address it. that was deliberate.)

Jeff B.