Question How to design a FIFO database (1 Viewer)

Moore71

DEVELOPER
Local time
Today, 01:28
Joined
Jul 14, 2012
Messages
158
Hi guys,
As a follow-up of my recent questions on Item expiration, I have discovered that the solution should be a FIFO system (first-in,first-out).
My question here now is how do i go about this FIFO designing.
Does anyone has an idea or rather sample FIFO database for me to learn from?

Any idea will be appreciated.
Thank you all in advance.
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 21:28
Joined
Jan 23, 2006
Messages
15,364
Did you try searching this forum for FIFO?
I have responded to posts, but I do not have a background/experience in logistics per se.

You'll get some info from the exchange here.

Sample database here.

I did not create these databases.

Good luck
 
Last edited:

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 20:28
Joined
Feb 28, 2001
Messages
27,001
In general, a database isn't FIFO or LIFO or any other order. It is the queries that impose the order. There is no reason why you couldn't insert your data either by date or with a simple autonumber (the autoincrement kind). Then put in what you need to put in for a table and let the date or autonumber "do its thing." When you want to extract the stuff that went in first, you do so through a query that imposes the "Find first n widgets order by your key field name goes here ascending"

The only catch is that you probably need a marker field so that once you select some records, you can mark them, copy them to where they need to be, and never use the marked records again.
 

Users who are viewing this thread

Top Bottom