Hello again guys.
I'm having some trouble autofill on one of my forms. The form is a recipe collation form.
Just a bit of info as to why: As part of trace, it is a requirement that each ingredient of a recipe is logged with the ingredients batch code that is used for the specific ingredients within that recipe. These batch codes are logged in on a inventory table upon delivery. Each delivery is given a unique ID number. This unique number needs to be logged in on the recipe collation.
I'm trying to have it so that when a recipe is called for collation, the batch codes autofill with the batch that was brought into site first (basic stock rotation rules - first in first out). Screenshot provided of the recipe collation form. KEY and Step by Step guide to how I use it.
A - First, the user inputs the mix number. This is added to the finished Batch Code
B - This is the recipe selection menu. When selected, the recipe appears in the subform below with its required ingredients and amounts
C - SubForm that loads when recipe is selected. Each ingredient and target weight is shown here
D - Completed batch code based on mix number, julian date, department and job number
E - a simple "Tag" that is copied and attached to the racks for reference purposes for packing department - not saved, its just for the users needs
F - ingredient stock code ****** this is for this post.... I need it so when you select the box it will either:
** Autofill based on stock values
** open a subform showing all the different stock codes and amounts, and when entry is selected, put this code in the F box
G - Actual amounts - amount used is typed in here and deducted from the stock table
(I plan later in the year to have a scale linked to the COMM1 port of the system and pulled data from it, but for now, typing it in is fine. one step at a time)
H - Job number - autonumber that is used for storage and part of the batch code
So... any ideas guys? its baffling me, doesn't seem to work. Possibly due to the amount of tables used in this system... The following tables are used:
inventory stock - (INV_STOCK) - stores the ingredients and the delivery dates. Contains the ingredient codes and stock values I need in this
linked to INV_STOCK:-
*** ING_DATA - shows the ingrdients information used to store the data
Recipe table - (tblRecipes) - Recipes are made on a different form and stored here. This stores each ingredient for each recipe, each target amount, and stores is under a unique recipe ID.
Recipe Collation (tblDailyFG) - the screenshotted form loads recipes up from their unique recipe ID, loads their ingredients in the sub form. Once data is recorded, it stores it under the job id (Daily_FG_ID) or "H" on the screenshot
Any help would be greatly appreciated!
Crys