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+h...@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