On Friday 22 February 2008 11:25:58 John Jason Jordan wrote:
> I have a field I use for selecting records in a database of test
> questions by placing unique strings in the field. For example, I might
> enter "FE1a-001" which means that it will be merged into Final Exam 1a
> and will be question #1. This works well, but sometimes I need to merge
> the same question into other documents. For example, if I want the same
> question to appear in Final Exam 3c as question #30 I need to enter
> "FE3c-030" in this field as well.
>
> I can add both values in the field, but then the select queries do not
> pick up the record at all. I need the LIKE operator to function as long
> as the string occurs *anywhere* in the field, not that the field be
> *the same as* the string.
>
> I tried adding a new field, but Base informed me that if I did so it
> would delete all the data in the table!
>
> I need to get the project delivered to the customer by Monday morning
> so I'm getting desperate for a solution. The Help file has nothing
> about how the syntax is supposed to work. Are there other operators
> besides LIKE? If so, what are they, and how do they work?
Sounds like you need to do some modifications to your Base file. Create a
file with a field for your unique strings. Then in your form replace the
field for this string with a dropdown box that is linked to this new table.
Then you should have no problem changing the entry in this dropdown box and
having the question place where you want it in the test in which you want it.
I think there should be some directions for setting up this table and the
dropdown box as well in the Getting Started with Base chapter of the Getting
Started Guide available at:
http://documentation.openoffice.org/manuals/oooauthors2/.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
