can I just do a sanity check, too?
My main table has an ID field (autonumber), therapist field referring to the therapisttable (number field), patient field referring to the patienttable (number field), therapy field referring to the therapytable (number field).
The patienttable, tehrapisttable...