> It is perfectly possible, the parent table doesn't need the adjuster_id
> field. Yours is a common misunderstanding about how relations work. A
> relation is an implicit seek going on in the child table. The seek is
One teeny clarification, but it's not relevant in this case.
The relation goes from parent to child when viewing the information,
such as in two BROWSEs where you scroll through the parent and want to
display all of the related children.
The relation goes from child to parent where you want to print a report
and you have multiple invoice detail lines (the children) per invoice
header (the parent).
/Paul