How to do this? [message #82588] |
Wed, 11 June 2003 10:24 |
Anand Chiney
Messages: 7 Registered: April 2003
|
Junior Member |
|
|
Hi
I have a table named Designation with fields
SrNo and Designation, where Srno is Primary key.
Another table, Master stores Srno, instaed of
whole Designation. This is to save the Database size.
In the master table the Srno is a foreign key.
While firing execute_Query, the detail block is
displaying Srno but i want to display the designation name
How to do this? Which trigger to use to catch the
record before displaying it in the Text Items so that
i can change the Srno to Designation Name?
Thks in advance
|
|
|
Re: How to do this? [message #82594 is a reply to message #82588] |
Thu, 12 June 2003 00:18 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Include a Text/Display Item (database property = FALSE) "Designation" in the block , which can be filled thru the POST-QUERY on the master block. Create a function get_designation in your program units that queries the Designation table for a given Srno.
MHE
|
|
|