G
Guest
I have an Access 2003 front end application that is linked to a SQL 2000
backend. (ODBC) I have two related tables (Parent-Child, one to many
relationship.) primary key in parent named ID which is an Identity type field
in SQL and a related field named ID in the child.
If I create a new form-subform combination in the Access front end the
subform linker wizard builds me a correct SQL Statement such as "Show CHILD
TABLE for each record in PARENT TABLE using ID"
However, one of my existing forms has an incorrect SQL statement like this:
"Show CHILD TABLE for each record in <SQL Statement> using ID".
I cannot get it to create the right SQL Statement. Any help out there? Is
there a way to manaully edit this property? I cannot seem to find one.
backend. (ODBC) I have two related tables (Parent-Child, one to many
relationship.) primary key in parent named ID which is an Identity type field
in SQL and a related field named ID in the child.
If I create a new form-subform combination in the Access front end the
subform linker wizard builds me a correct SQL Statement such as "Show CHILD
TABLE for each record in PARENT TABLE using ID"
However, one of my existing forms has an incorrect SQL statement like this:
"Show CHILD TABLE for each record in <SQL Statement> using ID".
I cannot get it to create the right SQL Statement. Any help out there? Is
there a way to manaully edit this property? I cannot seem to find one.