Forum

Master table not linking to detail table

More
4 years 5 months ago #26 by David Hicks
Master table not linking to detail table was created by David Hicks
Overview: 2 tables.  Master with member name and details.  Detail with history of participation.  "msid" is the primary key to Master.  "partid" is primary key to Detail.  Detail has secondary key "msid" which links to Master.  When I run the tables and select a member from the Master, the link fails to the Detail.  

I am attaching Pictures of the Master and Detail SQL sections and a copy of the Trace file when I run the tables.

File Attachment:

File Name: JCTable-tr...file.txt
File Size:1 KB


Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 1 month ago #27 by JoomCode Support
Replied by JoomCode Support on topic Master table not linking to detail table
In your detail table, in the Master link ID field, you reference "jos81_aparticipants.msid", which references the master table.
msid is in fact a field in the detail table, so if you take out the master table reference, and only use "msid" it will work as expected.

As a side note, all fields do not need to be referenced by the table name, you only need to reference the field name
 

Please Log in or Create an account to join the conversation.

Time to create page: 0.258 seconds