Subdatasheets for linked SQL Server Tables

[Douglas Lane]

I would appreciate any help with this. At my wit's end.

I have an access front end linking to SQL Server tables on the back
end.
One of these linked tables had a subdatasheet to another of the linked
tables, until I changed the schema on some tables and relinked them.
Now I cannot re-establish the subdatasheet link!!! Creating the
relationship in access doesn't work and the INSERT subdatasheet
command stays greyed out. No problem if I import the data into access,
but that's not an acceptable solution for me.

HELP>

[DFS]

Douglas,

I believe you can do this:

1) write a query against your main table: SELECT * FROM TABLE

2) write a query against the table you want to use as the subdatasheet.

3) Open query #1 and choose Insert | Subdatasheet and use query #2


"Douglas Lane" <dl***@virginia.edu> wrote in message
news:bf**************************@posting.google.c om...

I would appreciate any help with this. At my wit's end.

I have an access front end linking to SQL Server tables on the back
end.
One of these linked tables had a subdatasheet to another of the linked
tables, until I changed the schema on some tables and relinked them.
Now I cannot re-establish the subdatasheet link!!! Creating the
relationship in access doesn't work and the INSERT subdatasheet
command stays greyed out. No problem if I import the data into access,
but that's not an acceptable solution for me.

HELP>