D
Dmitriy
I currently have a database in Access 2007 that I want to convert to SQL
Server 2005, but I want to keep Access as the front-end so that I can
continue to use the forms. The tables and queries will be in SQL Server.
The form I'm having trouble with has a drop-down menu with a list of codes.
It has a subform which displays records matching the code selected. The
information comes from a query that selects certain records from a table
(based on other criteria). This is all designed using link master fields and
link child fields. The problem is that when I upsize to SQL Server, this
feature doesn't work anymore. Nothing happens when I select a code from the
drop-down menu. I know the query works, and the form does get records from
it, but changing the code doesn't do anything. I'm guessing that the problem
is with link master fields and link child fields. Is there any way to make
the linking work?
Server 2005, but I want to keep Access as the front-end so that I can
continue to use the forms. The tables and queries will be in SQL Server.
The form I'm having trouble with has a drop-down menu with a list of codes.
It has a subform which displays records matching the code selected. The
information comes from a query that selects certain records from a table
(based on other criteria). This is all designed using link master fields and
link child fields. The problem is that when I upsize to SQL Server, this
feature doesn't work anymore. Nothing happens when I select a code from the
drop-down menu. I know the query works, and the form does get records from
it, but changing the code doesn't do anything. I'm guessing that the problem
is with link master fields and link child fields. Is there any way to make
the linking work?