This is a minor issue that can be solved with a VC, but I would like to understand what I am doing wrong, or if this is simply not meant to work the way I expected.I have a parent table (session), with related child entries (session_users). There is ...

Parent: User_Session key session_id, each row is a game session that has 2 related players.Child: User_Session_Player ref to parent via ref_session_id, each row is a player's parameters, including a spirit they played, which is a ref to SI_Spirit tab...

I have what I believe is a syntax issue, but it may be another mistake I have made.I have a table Task, which has person_id , which is a Ref to table Person[id] (required "primary contact")The table Contact, is a part of Task, and each row has a pers...