[Solved] Inventory and item tracker

Creating and using forms

[Solved] Inventory and item tracker

Postby Ozwallt » Mon Feb 24, 2020 11:22 am

Hi
Very new to the database world so please forgive my absolute ignorance on the issue. All help is greatly appreciated!
I'm creating a form to track items that will be booked
out /returned by individuals and have hit a few stumbling blocks which I'm sure are pretty basic.
1. I've created a list box which lists the Item ID numbers and I need that to populate the next 5 fields with the data in the table. At the moment it merely alters the list box so I need to link the other fields somehow.

2. I need to keep a record of items booked in/out and (when) for auditing.

Does anyone know of any templates that would work or offer any tips please?
Ta
Last edited by RoryOF on Tue Feb 25, 2020 9:30 pm, edited 3 times in total.
Reason: Added green tick [RoryOF, Moderator]
Ozwallt
 
Posts: 2
Joined: Sun Feb 23, 2020 10:35 am

Re: Inventory and item tracker

Postby Villeroy » Mon Feb 24, 2020 12:02 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Inventory and item tracker

Postby Ozwallt » Tue Feb 25, 2020 5:23 pm

Thanks!
Open office 4, windows 10.
Ozwallt
 
Posts: 2
Joined: Sun Feb 23, 2020 10:35 am

Re: [Solved] Inventory and item tracker

Postby Villeroy » Tue Feb 25, 2020 11:17 pm

You're welcome.
The articles are stored with a name and an automatic ID (a unique "row number" which serves as a primary key).
Both tables "Input" and "Output" have an automatic date-time stamp, another automatic ID and an article ID which refers to the ID in table "Articles" (see menu:Tools>Relationships) which means that you can not enter any article ID in the Input/Output table before the ID exist in the articles table (this is called "referencial integrity").
The "Input" form writes new records only to the "Input" table. The form is set up to write new records only.
The "Output" form writes new records only to the "Output" table.
The queries perform the calculations and the merging of the different tables. "qInventory" is made from "qInput" and "qOutput".
The "Edit" form shows the in/out history for each selected article plus the calculated balance made from "qInventory".
All the listboxes in the forms store an article ID in the In/Ouput table by letting you choose one article from the dropdown. It is not the article name that is stored. What you store is a reference number according to what you see in the relations window (Tools>Relations...).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest