OraFAQ Forum: Forms » retrieve two table information in same tabular form

Home » Developer & Programmer » Forms » retrieve two table information in same tabular form

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

retrieve two table information in same tabular form [message #264204]

Sun, 02 September 2007 00:37

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

Report message to a moderator

Re: retrieve two table information in same tabular form [message #264208 is a reply to message #264204]

Sun, 02 September 2007 00:52

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

Report message to a moderator

Re: retrieve two table information in same tabular form [message #264583 is a reply to message #264204]

Mon, 03 September 2007 20:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 12:17:38 CDT 2025