Retrieve records and create a list/report

English
#1

Is it possible to do the following:
Ideally I would use a barcode scanner to populate a field in a form, but I could also type in the barcode.
I want the form to then retrieve the matching records from the database and populate preselected information into a list. I don’t want to filter, because I need this list to compile all of the items I scan or enter manually.

That list would need to be printable, maybe as a report?

So for an example, checking out books from a library. I need to scan each book, then generate a list of those scanned books that I can print out.

I hope this isn’t confusing. In my head it makes perfect sense.

I’m using Windows 10, Libre Office version 7.3.0.3 and HSQLDB Embedded.

#2

Hello,
Please always include your OS, specific LO version and the database you are using as this can affect the answer.
.
Thought here would be to use a temporary table. Data is entered or scanned (I have not used a scanner in Base so no help there) and you can generate a report from it by a simple query containing a join to the table containing the data.

#3

Had written something like this for the Base Handbuch in German, translated as Base Guide. Databases Base Guide 6.2. The main example is a database for libraries. Also described in this database how to use barcode with this libraries. Tested it with a simple scanner.

Print output isn’t planned in this example, but output for reminder.

#4

Thanks, that will get me started!

Edited my initial post to include OS, etc.

#5

I will take a look at the example you provided. Thank you.

#6

I guess I’m asking the wrong questions…or I’m biting off too much at once. None of this is helping/making sense to me.

What I have:
I have a table with a list of inventory that is sorted by a unique ID number. I have other tables that I am using to create dropdown menus within my main form. That form gives me a display of the inventory table and the ability to edit/add/delete records.

What I need:
I need to be able to search/filter by the unique ID and then add the selected item from inventory to a list (a temporary table?) … Then I would search for another item and add it to the next line on that list, and so on, until I have all of my needed items selected and added to the list.

Once I figure that out, I would like to be able to edit the items in bulk–for instance, they have an “In Stock Status” check box. Could I check or uncheck that box on all items in the list?

This is a multistep process I know, and I’m very new to databases…so help is greatly appreciated, but the examples I’ve been given so far aren’t helping me connect the dots. I don’t know exactly how to reverse engineer them.

#7

Best will be you will upload a little example, which could show the problem.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.