Re: [libreoffice-users] Auto Filling Drop Down Boxes

Hi :)
I would stay with Access for now.  There is almost no-one working on Base so it's gradually getting 
worse as regressions slip in.  
Regards from
Tom :)


--- On Wed, 21/9/11, stripedtomato <email.stripedtomato@yahoo.com> wrote:

From: stripedtomato <email.stripedtomato@yahoo.com>
Subject: [libreoffice-users] Auto Filling Drop Down Boxes
To: users@global.libreoffice.org
Date: Wednesday, 21 September, 2011, 18:00

Hello,

I am wanting to do something in Base, but I am not sure what the “action”
(auto filling?)  is called, so I am not sure what subject to research.  If
you could let me know what I should be researching, or provide an example,
it would be appreciated.

I have three drop down boxes: City, State, Zip as part of an address record. 
As of now, I have to make independent selections for each of these drop down
boxes.  What I would like to do is when selecting a city from the drop down
box list, then related state and zip information would automatically be
filled in, in their respective drop down boxes, and the information stored
in their respective db cells.

For example:
By selecting MINNEAPOLIS from the City drop down box list, MN would
automatically be filled in, in the State drop down box, and 55407 would
automatically be filled in, in the Zip drop down box.

Or, by selecting TAMPA from the City drop down box list, FL would
automatically be filled in, in the State drop down box, and 33605 would
automatically be filled in, in the Zip drop down box.

I am moving my db from Access to LibreOffice, so I know Access much better,
but I was never able to figure this out in Access either.  If you happen to
know the answer in either Access or Base I should be able to figure it out
from there.

Thanks in advance!

--
View this message in context: 
http://nabble.documentfoundation.org/Auto-Filling-Drop-Down-Boxes-tp3356073p3356073.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted