OraFAQ Forum: Forms » Dynamic list from one table and insert into another

Home » Developer & Programmer » Forms » Dynamic list from one table and insert into another (Oracle 10g)

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

Dynamic list from one table and insert into another [message #574481]

Thu, 10 January 2013 14:54

vinxz
Messages: 4
Registered: January 2013
Location: Fiji

Junior Member

Hi All

Im facing some issues with my form, getting stuck... prob desc below :

I have Table A which has columns; car_year, car_type, line_num, line_text.
Table B has country, car_year, car_type, line_num, data_entry_amt.

Table A contains data which gets updated once every year only. Contains what year model is the car, what type of car it is.. Line_num has numbers starting from 1 which indicates the different part number and line_text has description for that line_num. eg :
2010 Toyota 1 Windshield
2010 Toyota 2 Door
2010 Toyota 3 Tire
2010 BMW 1 Windshield
2010 BMW 2 Door
2010 BMW 3 Tire
2010 BMW 4 Rear_mirror

Table B contains specific data related to table A, Contains country where car details n prices are, car_year, car_type, line_num, and amount($) for that part. for example :
Australia 2010 Toyota 1 400.50
Australia 2010 Toyota 2 200.40
Australia 2010 Toyota 3 308.25

So in year 2010, in Australia, Toyota's Door was sold at $200.40

Now, Table A will have similar data for this year and users will enter data for table B throughout this year. I tried master-detail form for this but it doesnt work. Because every year line_num change in table A and therefore cant implement a fixed number or rows on the form for amount for table B.

Someone told me to use dynamic listing but im not familiar with it. So if anyone has any idea how i should go about doing this then please let me know.

My form has structure has below :

Country Car_year
____________________________________________________

table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt

When clicked on save, data on table_B.data_entry_amt on this form should go n insert into table B.

Thank you

Report message to a moderator

Re: Dynamic list from one table and insert into another [message #574483 is a reply to message #574481]

Thu, 10 January 2013 15:04

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

Senior Member
Account Moderator

As you can't base a block on two tables (which is what you described), you could create a view and base data block on that view. Then, create INSTEAD OF triggers for updating/inserting/deleting records and that should work just fine.

Report message to a moderator

Previous Topic:	Forms9i not running at IE8
Next Topic:	Need help for My Tree Node icons and where the icon files are located

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:32:36 CDT 2024