Radicore Forum: Data Dictionary » Related Tables using different names fo primary Key Columns

Members

Help

Home

Home » RADICORE development » Data Dictionary » Related Tables using different names fo primary Key Columns

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Thu, 29 October 2009 11:41

dicelord
Messages: 5
Registered: October 2009
Location: Tampa FL

Junior Member

I have a parent table with PK pid.
I have a child table with FK to parent fkid.

I build a relationship between the two tables mapping pid to fkid.

I then build a LIST2 screen I observe the $inner_where in std.list2.inc has pid='5' it should be fkid='5'.

I am running Radicore v1.51.0

I am sure I have made a silly mistake. Please help!

Paul Kratz

Report message to a moderator

Thu, 29 October 2009 16:15

AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK

Senior Member

You have misunderstood how the parent relationship details in the Data Dictionary are used. They are used to construct the ON clause in JOINs when an sql SELECT statement is constructed, as documented in Using Parent Relations to construct sql JOINs.

They are not used to modify the WHERE string which is passed from one object to another as the receiving object has no idea which relationship is being used. This is documented in Different names for the same field.

This is also described in FAQ129.

[Updated on: Fri, 30 October 2009 09:14]

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator