Hello, I created vehicle inventory forms and I divided the vehicle into parts (cabin part, right side door, left side door, rear cell) so I created inventory forms for each sector. . however the forms add a row to the data table each time. Can’t we plan to save all the forms on the same data line so that this inventory only occupies a single line? thank you for your comeback
A form will always add a new row, that is its purpose.
If you want to edit an existing row, you should use an Edit Screen.
Is there another way to get around the problem?
I don’t understand. This is the correct way to do it - why would you not do it this way?
I do not want to edit what is already recorded but add the other compartments of the vehicle on the same data line. I want to get only one line per day of the complete vehicle inventory. the vehicle is checked every day by the guard staff
Do you want to add a new row every day, or just keep updating the same row over and over again every day?
I explain every morning the equipment inventory of the ambulance is carried out. as there is a lot of material, I sectored the verification by sector and therefore made a form for each sector all on a single data table. However, each time an inventory form is performed, it fills a data line in the table. Currently I have 9 vehicle sectors which corresponds every morning to 9 lines of the data table per day. but the verification is done every morning, so that makes 9 lines on the table every day. I am therefore looking to carry out an inventory of the vehicle through an application
If I’m understanding this correctly, you have 9 areas.
Each day you’d like their inventory updated.
Assuming you do not need a history of the inventory (Which you have not noted) you could do as Darren mentioned and do an Edit Form but have the edit form edit a temporary column for each inventory item.
Then, only when the edit form is completed do you set the column values for the main inventory line item and clear the temporary items.
This would allow updating of each item in inventory for each area (sector) but also ensure that inventory is done before overwriting the previous days inventory.
actually I forgot to mention that I need a history and that is precisely the point of the application to find how long the equipment has been missing or broken! I apologize for forgetting this very important detail.
I’ve built something similar to this for a client.
You will actually want to create rows on each inventory update, otherwise you can’t get the history of the items because the alternative to creating rows is creating columns, which is manual.
I think I’d structure this in 3 tables:
-1 table for Areas (sectors)
-1 table for Items (Items would belong to an area)
-1 Big Table for Inventory entries
Then there are a few ways to do the UI to submit entries.
The Inventory entries table would how the following columns (minimum):
-Item Row ID
-relation to item
-Area Row ID
-relation to area
-Quantity
-Timestamp or date inventory was taken
This relational structure would allow you to see all entries for each item and all quantities with history for each area.
There are some Queries that would need to happen as well, but that would be my recommendation for a structure.
