OraFAQ Forum: Forms » How to change list item

Home » Developer & Programmer » Forms » How to change list item

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

How to change list item [message #112979]

Wed, 30 March 2005 06:01

mrpranab
Messages: 32
Registered: March 2005

Member

Hi,

Say i have 2 fields...

1.Country Name and 2.State Name

When i click on the country field i only want
to see that particular states of the country
in the state field.If i change the country the
changes in the states should also appear

How to do it in the d2k 6.0 ver.

Thanks.

Report message to a moderator

Re: How to change list item [message #113145 is a reply to message #112979]

Thu, 31 March 2005 02:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay ... two fields ... :blk.country and :blk.state.

Create an LOV on the 'country' ... should be straight forward.

Create an LOV on the 'state'. Put the ':blk.country' in the 'select' statement of the LOV or the record group on which the LOV is based.

Is that enough information for you to work it out?

If you want to get a bit more sophisticated you can populate both the Country and State from the one LOV. Read the books, think about it, and get back to this forum if you have problems.

Report message to a moderator

Re: How to change list item [message #113148 is a reply to message #113145]

Thu, 31 March 2005 03:46

mrpranab
Messages: 32
Registered: March 2005

Member

Ok thanks.

I was trying it in the when-list-change trigger and
to solve the problem but I think the 2nd solution
is better to get the result.

Pranab

Report message to a moderator

Previous Topic:	UPDATE
Next Topic:	diff between post - query and post - select

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 03:58:17 CST 2025