PLEASE HELP!! Problem!!
Hi i am creating a stock control database and i have problem each item needs a use by date and batch number but newer stock of the same item will have a different use by date and obviously new batch number. So how can i have multiple batch numbers and use by dates.. is this possible??
Maybe could work with a drop down menu?? or show in different table?? i have no idea..
I am using the lates FileMaker...