OraFAQ Forum: Forms » LINKING DIFFERENT FORMS

Home » Developer & Programmer » Forms » LINKING DIFFERENT FORMS (forms6i,windows 2003)

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

LINKING DIFFERENT FORMS [message #480362]

Fri, 22 October 2010 11:34

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

Hallow partners
please assist me in the following problem.
am using oracle forms 6i on windows 2003 server.

I have two tables Loan and deduction

Loan(
loan_number number(5)unique not null,
loan_name varchar(15)not null,
loan_type varchar(15)not null,
actual_amount number(10)not null,
taken_date date not null,
loan_purpose varchar (30)not null
)
/
deduction(
loan_number number(5)unique not null,
paid_amount number(10)not null,
transaction_date date not null
)
/
Both have loan_number columns as the primary key.

I created two separate forms using loan table and Deduction table.

Also according to requirement, when commiting in the loan form ,if 'loan_purpose' is 'PERSONAL' THEN deduction form SHOULD BE OPENED.

I MANAGED TO DO ALL OF THE ABOVE .

WHAT I WANT IS when deduction form pops up, it should have a matching loan_number as in loan form
What shall I do to achieve this???.

please assist.

Report message to a moderator

Re: LINKING DIFFERENT FORMS [message #480364 is a reply to message #480362]

Fri, 22 October 2010 12:41

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You could set a GLOBAL variable and then use that in the second form in WHEN-NEW-FORM-INSTANCE.

Report message to a moderator

Re: LINKING DIFFERENT FORMS [message #480414 is a reply to message #480364]

Sat, 23 October 2010 16:21

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

tHANK YOU joy_division

BUT HOW AM I GOIN TO ACHIEVE THAT??

PLEASE PASTE AN EXAMPLE

THANK YOU.

Report message to a moderator

Re: LINKING DIFFERENT FORMS [message #480415 is a reply to message #480414]

Sat, 23 October 2010 16:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use of global variables is described in Online Forms Help System. Take a look.

Report message to a moderator

Re: LINKING DIFFERENT FORMS [message #480416 is a reply to message #480414]

Sat, 23 October 2010 17:07

kilimanjaro
Messages: 151
Registered: May 2009
Location: Tanzania

Senior Member

THank you everyone.

i managed to solve the problem using global variable.
Thank you very much.

Report message to a moderator

Previous Topic:	How to get values from DB before update
Next Topic:	./frmbld.sh: line 105: fg: no job control

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 18:48:15 CST 2025