On Saturday November 17 2007 01:12 pm, Devin Renberg wrote:
> Hi,
>
> I setup a real estate database using open office. The database is based
> on a phone survey of potential customers. One of the questions of the
> survey is "which neighborhoods do you want to live in?" the answers are
> in a list drop down so you can select multiple neighborhoods in one cell
> for each potential customer. So for example John Doe Might Say he would
> live in Lincoln Park, Lakeview or Old Town. How do I filter so I look at
> all records for just Old Town? All three neighborhoods have been
> selected from the list and are located in one cell. When I try to do a
> filter of just Old Town no records appear. I think its because the
> filter is looking for cells that just have Old Town not Old Town,
> Lincoln Park and Lakeview. So how do specify the parameters so that it
> pulls records with more than one neighborhood so long as it has Old Town
> in it?
>
> Thanks for your help.
>
> Devin
I know I am a little late in answering this question. But are you using
Calc or Base? You spoke of cells which would be Calc (spreadsheet). In a
database, entries are placed in fields.
What you need to do is to create a database in Base. Probably two
tables would be sufficient: one for the questions with only one answer
including the person's name, and a second one containing the names of the
neighborhoods. When generating the form for the questionare, you would
want the first table as the main form and the second table as the subform.
"Getting Started with Base" in the Getting Started Guide shows you how
to create a form with a subform. It is available at:
http://documentation.openoffice.org/manuals/oooauthors2/.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
