I am creating a new database and I want a lookup box where I can type in the customerid and retrieve the data associated with that row in the database. I also need a way to clear all fields to enter in new data in the form. Thank You very much. Still learning.
Hello,
.
For lookup you can use filtering. See Apache OpenOffice Community Forum - [Example #1] Filter/Search with Forms (leveraging SubForms) - (View topic)
.
As for clearing all fields, this is just deleting the record and entering a new one. Does not make sense as to why you would want to clear ALL fields in a record.