Radicore Forum: How To » Display field from Related table 2

Home » RADICORE » How To » Display field from Related table 2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Display field from Related table 2 [message #839]

Tue, 22 May 2007 10:46

bclark
Messages: 4
Registered: April 2007

Junior Member

I am trying to get a field from a related table to be displayed on a child table's form but have had no luck. I've tried to mirror the config in the Xample database and I've read the original topic opened on 8/2006 that explains how the teacher_id translation works. But I'm still not having any luck.

Where can I begin troubleshooting to find where it's failing? I've setup the JOINS automatically and indicated that the required field be a dropdown list on the jr table. Do I need to build this list somewhere or is it done automatically?

Thanks for your help.

Bryant

Report message to a moderator

Re: Display field from Related table 2 [message #840 is a reply to message #839]

Tue, 22 May 2007 13:55

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

Senior Member

Is the field not being displayed at all, or is the dropdown list empty?

For a field to be displayed the following must happen:

The fieldname must be in the screen structure file to tell the XSL stylesheet where to put it.
The fieldname and its value must be in the XML file which is extracted from $this->fieldarray for that database object. This is either done within the sql SELECT statement, or added in manually.

If the dropdown list is empty then you have not supplied the list of values. Please refer to any of the following:

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

Report message to a moderator

Previous Topic:	many-to-many
Next Topic:	table related to itself

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 12 08:26:58 EST 2026

Total time taken to generate the page: 0.00887 seconds