[Solved] Search Form ID Numbers/Text
Posted: 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.
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.