MS Access 2007 Back end and Front End Table Problem 1

[iuianj07]

Hello Guys,

I have a DB that I used the Split Database method to split into two files (one backend where all the tables are stored and the other is the front end where all forms, queries reports, macros and linked tables are located)

Anyhow, from the Backend DB, I created a relationship between 2 tables, the JobTracking Table and IssuesTable wherein JobTrackingID from JobTracking Table and JobTrackingID from IssuesTable are linked. Whenever I look at the JobTracking table, on the very left side of there is the + sign that opens up the related record from the IssuesTable (don't really know the term to use ) Which should be correct. My problem though is when I go to the FrontEnd DB and open the JobTracking Table, it doesn't have that + sign on the very left side. Is there a way that I could make that show up there?

Any help is greatly appreciated.

 

[dhookom]

These are subdatasheets. I typically run code that sets all of these to [none] since I don't use them.

If you really want to use this feature with linked tables you can go to the design view of the parent/master table and set the Subdatasheet propert to the child table name. For instance linking to the Orders and Order Details table in Northwind, the enter in the Orders table design would be:
[tt][blue]
Subdatasheet Name: Table.Order Details
Link Child Fields: OrderID
Link Master Fields: OrderID
[/blue][/tt]


Duane
Hook'D on Access
MS Access MVP

 

[iuianj07]

Thank you dhookom.