Home » Developer & Programmer » Forms » retrieve two table information in same tabular form
retrieve two table information in same tabular form [message #264204] Sun, 02 September 2007 00:37 Go to next message
hira97013
Messages: 4
Registered: August 2007
Junior Member
PROBLEM DESCRIPTION
step1:
table structure

database has two table table1, table2

table1 field is
id name qty
table2 field is
id name qty sellqty

now table1 has some data say
id name qty
1 a 10
2 b 20
so on

step2:
now in form i create a tabular form,which has table1 information,also the tabular structure is table1

id name qty and sellqty

setp3:
when i retrieve information from form tabular say when i press
id 1 from the field tabular first row it show other two information on the other two field on the tabular figure is

before
id name qty sellqty
1

after
id name qty sellqty
1 a 10

now in the first row in the sellqty column i enter a sellqty say 2,the tabular look like the following

id name qty sellqty
1 a 10 2

then when i press enter to go next row then tabular look like following

id name qty sellqty
1 a 8 2

that time the tabular information will store in table2 using form trigger

again when i retrieve the same id information i show the table2 information i look like the following

id name qty sellqty
1 a 8 not sellqty

now when i again enter a value in the sellqty it will show like

before
id name qty sellqty
1 a 8 1 press enter

after
id name qty sellqty
1 a 7 1

and when i go the third row it will store information on table2
so on

please some one can help
S.M.BAHAUDDIN BAKHTIAR
hira97013@yahoo.com



Re: retrieve two table information in same tabular form [message #264208 is a reply to message #264204] Sun, 02 September 2007 00:52 Go to previous messageGo to next message
bbaz
Messages: 138
Registered: April 2007
Senior Member
please some one can help
S.M.BAHAUDDIN BAKHTIAR
hira97013@yahoo.com



It would be better for all the users of this forum to share the information and not to have it sent via emails (one-to-one).

Kindly can you inform us how you are currently using both Tables to populate your Tabular data block. Are you using a UNION on the tables?

Please provide the Code behind the Trigger that you claim updating the Table/s when changes take place in the Block. This makes it easier for others to understand your problem and try to help you resolve it.

Regards,
Baz
Re: retrieve two table information in same tabular form [message #264583 is a reply to message #264204] Mon, 03 September 2007 20:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Base your block on the main table and then get the extra information from the other table via the 'post-query' trigger and populate non-database fields. If you have to update or insert information for this second table then do the work on the second table in post-update and post-insert triggers.

Please read the sticky and next time post table definitions and insert statements of the table data. Also use the code tags so that the information you post uses a fixed font. It makes reading 'screen layouts' so much easier.

David
Previous Topic: Query in text field
Next Topic: Can we check the status of the calling form in the called form
Goto Forum:
  


Current Time: Sat Dec 10 11:14:04 CST 2016

Total time taken to generate the page: 0.09807 seconds