Master/Detail warning at design-time

[ClaytonAguiar]

Hi,

The below query is the detail in a master-detail relationship. When I set the Master property, I get the message "". There IS a FK constraint.

select id, name
from teachers
where
id not in (
select t.id as id
from assignedteachers at,
teachers t
where
(at.IDScheduledCourse=:ID) and
(t.ID = at.IDTeacher)
)

The detail table HAS a FK Constraint with the master table (ScheduledCourses).

Is that a warning? An error? Any missing parameter/property?

 

[ClaytonAguiar]

Forgot to write te message:
"Automatic Master/Detail configuration is only possible if a foreign key constraint exists between the master and the detail table.

 

[ClaytonAguiar]

Solved setting AssignedTeachers at the UpdatingTable property. As this query is read-only, no weird results are expected to happen. But this solution doesn't seem to be "obvious". Does it?

 

[Marco Kalter]

It's only obvious after you find the solution

. Perhaps we should include the table names in the error message. That might have saved some time in this case.

------------------
Marco Kalter
Allround Automations