[Solved] Search Form ID Numbers/Text

Creating and using forms

[Solved] Search Form ID Numbers/Text

Postby AmyBUK » Tue Nov 06, 2018 6:44 pm

Hi

I'm new to Base and OpenOffice, and have been asked to create a Training Database for a colleague. I have created my tables, and I have created an input form for staff to use, which uses list boxes to ensure accurate input. The List uses the ID numbers as they are the primary keys, and then lists the text in the drop down list for ease. For example, my 'FullName' drop down has the following List Content:

SELECT "FullName", "OpID" FROM "Ops List" ORDER BY "FullName" ASC

However, I've just imported 1,800 records, and I'm finding it impossible to search for a record, as everything is logging the ID numbers (as it's supposed to).

Is there any way to search for text?

Thanks in advance for any advise or help.
Last edited by robleyd on Wed Nov 07, 2018 1:12 pm, edited 2 times in total.
Reason: Add green tick [robleyd, Moderator]
OpenOffice 4.1.5 on Windows 7
AmyBUK
 
Posts: 12
Joined: Tue Nov 06, 2018 6:36 pm

Re: Search Form ID Numbers/Text

Postby UnklDonald418 » Tue Nov 06, 2018 8:55 pm

Look at
[Example #1] Filter/Search with Forms (leveraging SubForms)
it is a long article, so scroll down near the end and download "LIKE_user_input_filter.odb"
Please let us know if you have further questions.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1085
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Search Form ID Numbers/Text

Postby AmyBUK » Wed Nov 07, 2018 11:37 am

Thanks :) That should help me perfectly.
OpenOffice 4.1.5 on Windows 7
AmyBUK
 
Posts: 12
Joined: Tue Nov 06, 2018 6:36 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest