Home » Developer & Programmer » Forms » How to do this?
How to do this? [message #82588] Wed, 11 June 2003 10:24 Go to next message
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 Go to previous message
Maaher
Messages: 7064
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
Previous Topic: Locking problem
Next Topic: Changing colors
Goto Forum:
  


Current Time: Mon May 16 20:04:44 CDT 2022