Hi there, I'm having some trouble getting this to work...
I have a few tables with data that needs linking and I'm thinking its through either VBA or Queries, not entirely sure so wondering if you guys can help me.
Here's a simplified description of the issue, I'll use this as an example:
Table 1- (Goods In)
ING_ID - ingredient ID (number)
ING_NAME - Ingredient Name (short text)
STOCK_ID - Stock ID (Autonumber)
Table 2 - (Recipe)
REC_ID - Recipe ID (Autonumber)
ING_ID - Ingredient ID (number)
ING_AMO - Amount required of each ingredient (number)
Table 3 - (Collate)
JOB_ID - This specific jobs batch code (Autonumber)
REC_ID - Recipe selected from list - populates the next two fields on the form with the requirements
ING_ID - Lists the ingredients used in this recipe
ING_AMO - shows amount required per ingredient for batch
******* STOCK_ID - drop down list shows values per ingredient of its STOCK_IDs in stock currently
Its the **STOCK_ID i'm having issues with. I need it to show the autonumber of the ING_ID in the list. Currently it seems to simply fill the entire list with the same number again and again. There is no filter?
How can I filter it so each on ingredient stock ID, the drop down list shows only please?
Screenshot provided - There is obviously more information than what I have listed here however for this exercise the above fields are only required.
Thank you for your help!