OraFAQ Forum: Forms » store and traverse multi record block data

Home » Developer & Programmer » Forms » store and traverse multi record block data

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

store and traverse multi record block data [message #395494]

Wed, 01 April 2009 11:19

marvSQL
Messages: 13
Registered: February 2008
Location: JAMAICA

Junior Member

hi

i am trying to solve a problem but dont know wich solution to use.

i have 2 data blocks
for example :

1. countries
2. cities

both blocks are multirecord blocks
each block are on its own tab page
(see attachment)
/forum/fa/5978/0/

if a country is selected then the user can click the cities tab and enter any amount of cities . the user can then go back to the country tab and enter another country record then click the cities tab and enter the cities for that country.
no record is to be saved or post to the database untill the user click the save button.

is there a way that i can store data of the country datablock and the cities datablock in memory...such that when the user selects a country and click the cities tab all the cities show up in the cities multirecord block?