Fifo

[DMol15]

I Want to implement a FIFO system in my database for Inventory. The only problem is When something gets taken out of its location or row, all other parts shift because that row/spot needs to get filled in. Say I delete a record in row 1 spot A1 because it got shipped to a customer, Now my part that I have in row 1 A2 is moving to A1 and so on. I want to keep A1 empty so next time I go to add a record/part it goes into the A1 spot or any other open spots, so I don't have to reorganize my parts evrytime one gets taken out and shipped.

[CarlettoFed]

A database is not managed like a spreadsheet, the data structuring conditions are different.

[CJ_London]

Better show your tables and relationships because what you are describing does not sound like they are correctly designed

[orange]

I agree with the other posters - your design needs to be reviewed. Also, I recommend you search the forums and youtube for samples of FIFO processes.

Here is one. There are others.
Youtube video

Good luck.

[CJ_London]

there are also plenty of examples in the links provided at the bottom of this thread