J
Joel D Kraft
I am having a problem with relationships on tables that are linked to SQL
Server via ODBC. My tables are linked and can be viewed and modified in
datasheet view just fine. I can edit the relationships on the database to
include these tables.
The problem is when I go into datasheet view for my master table, the [+]
icon to view the related data is not available. This works fine for
non-linked tables.
I know that the behavior is still supported because I have been using
hierarchical-dataset view of linked tables for years, and one is working in
this exact same database file. I am just unable to get it to work for NEW
relationships since I upgraded of Access 2007.
Server via ODBC. My tables are linked and can be viewed and modified in
datasheet view just fine. I can edit the relationships on the database to
include these tables.
The problem is when I go into datasheet view for my master table, the [+]
icon to view the related data is not available. This works fine for
non-linked tables.
I know that the behavior is still supported because I have been using
hierarchical-dataset view of linked tables for years, and one is working in
this exact same database file. I am just unable to get it to work for NEW
relationships since I upgraded of Access 2007.