- Posts: 1
- Thank you received: 0
Forum
- You are here:
- Home
- Forum
- Components
- JC Tables
- Master table not linking to detail table
Master table not linking to detail table
- David Hicks
- Topic Author
- Offline
Less
More
4 years 7 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.
I am attaching Pictures of the Master and Detail SQL sections and a copy of the Trace file when I run the tables.
Attachments:
Please Log in or Create an account to join the conversation.
- JoomCode Support
- Offline
Less
More
- Posts: 1
- Thank you received: 0
4 years 3 months 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
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.
