Sql sequence for drop lists.

janeitesarah · Post by **janeitesarah** » Thu Apr 10, 2008 12:35 am

I've been trying to put a drop down list into a form, and I'm having trouble with writing the SQL command. I'm following the directions on the Getting Started Guide, but it's not working. This is a database for a property management office, and I'm trying to link the lease violation values with the appropriate field in the form.

Could someone walk through this with me?

Thanks!

Sarah

RonIA · Post by **RonIA** » Sat Apr 12, 2008 11:56 pm

Have you tried creating the query and extracting the SQL statement from that?

janeitesarah · Post by **janeitesarah** » Wed Apr 16, 2008 5:39 pm

No, I have not. I followed the instructions in the Base guide to create the table, and then while creating the form to write the statement. When I wrote the statement following the instructions in the guide, it did not work.

Hungarian forum · Post by **r4zoli** » Wed Apr 16, 2008 9:00 pm

What OS and which OOo version?
If 2.4, it has a known bug with listboxes: http://user.services.openoffice.org/en/ ... =13&t=4463

janeitesarah · Post by **janeitesarah** » Wed Apr 16, 2008 9:15 pm

Thank you! I just put the "C" in where suggested in that thread, and it works now.

Sql sequence for drop lists.

Sql sequence for drop lists.

Re: Sql sequence for drop lists.

Re: Sql sequence for drop lists.

Re: Sql sequence for drop lists.

Re: Sql sequence for drop lists.