G
Guest
I have a form with two subforms on a tabbed control, each tab containing one
of the subforms. My link fields work on the second subform but not on the
first subform. Both subforms have their Link Master Fields set to the parent
form's ID field and their Link Child Fields set to their respective parent ID
fields (relationships created).
When I try to load the first tab I get the error, "The specified field
'TestData_Config.TestID' could refer to more than one table listed in the
FROM clause of your SQL statement." TestData_Config is the name of the first
subform and TestID is the Link Child Field that relates to the parent form's
ID.
The TestData_Config subform's datasource is a SQL view that joins two tables
of related data together...
"SELECT TestData_Config.*, TestData_InRack_Config.*
FROM TestData_Config LEFT JOIN TestData_InRack_Config ON
TestData_Config.InRackConfigID=TestData_InRack_Config.ID;"
The second subform is pretty much the same except it's datasource is a view
that combines 3 tables. However, I don't get an error message when I bring up
its tab.
Any ideas on what could be causing this error message? When specifying the
Link Child Field, I selected the TestData_Config.TestID field from the list
of available fields and it explicitly names the table as TestData_Config. I
don't understand why the error message says it could be referring to more
than one of the tables in the query.
of the subforms. My link fields work on the second subform but not on the
first subform. Both subforms have their Link Master Fields set to the parent
form's ID field and their Link Child Fields set to their respective parent ID
fields (relationships created).
When I try to load the first tab I get the error, "The specified field
'TestData_Config.TestID' could refer to more than one table listed in the
FROM clause of your SQL statement." TestData_Config is the name of the first
subform and TestID is the Link Child Field that relates to the parent form's
ID.
The TestData_Config subform's datasource is a SQL view that joins two tables
of related data together...
"SELECT TestData_Config.*, TestData_InRack_Config.*
FROM TestData_Config LEFT JOIN TestData_InRack_Config ON
TestData_Config.InRackConfigID=TestData_InRack_Config.ID;"
The second subform is pretty much the same except it's datasource is a view
that combines 3 tables. However, I don't get an error message when I bring up
its tab.
Any ideas on what could be causing this error message? When specifying the
Link Child Field, I selected the TestData_Config.TestID field from the list
of available fields and it explicitly names the table as TestData_Config. I
don't understand why the error message says it could be referring to more
than one of the tables in the query.