On Thu, May 2, 2024 at 6:37 AM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
> Presuming the id is unique in parent and child, what’s the value of the
> type field in the foreign key? Are you saying the PK on tableMain is
> (type,id), perhaps for clustering purposes?
>
>
>
Preventing the parent record from saying "tblOne" while the actual ID value
is present on "tblTwo".
David J.