| get calculated field from parent table [message #1947] |
Mon, 09 February 2009 13:23  |
ikatz
Messages: 40
Registered: December 2007
Location: Durham, NH
|
Member |
|
|
I have a table of people called "person", which lists contact information. I have a table called "staff", which associates a person_id with some job-specific data (their position, work phone number, etc).
For my staff table, Radicore's dictionary calculates a person_name from from the foreign key person_id, and this name appears in all the staff screens instead of the number. This is good.
I would also like to use the person_name value in place of staff_id for all the screens that have staff_id as a foreign key. But, the dict file alone can't do this. What is the best way to accomplish this in Radicore?
I assume I have to do something with an instance of the person table in the _cm_getExtraData method of the staff table's class... but I can't seem to figure it out.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
