Trying to get the information from one table based on two conditions in another table

[Itanova_Pastry]

Hello everyone,

First off all I’ll apologize in advance if my grammar is a little bit odd, English is my second language.

I’m working on an app for a pastry shop and I’m stuck trying to get the information from one table based on two conditions in another table.

The tables:
Recipe: a collection of all the recipes of the store.
Batches: a recollection of every time they bake, and the financial of the bake.
Batch detail: Store the details of the Batch made, recipes used, amount of ingredients used for this particular production. The deal is they can use several recipes in one Batch.

And the table that I need to fill.
Sales details: which is a recollection of the sales done by batch to compare the expenses and the income.

All the tables are connected to each other with REF relationships.

Now, I want to fill the column “recipe used” taken from the table “Batch detail”, but this will be based by the “Batch date” which belongs to the table “Batches”

So, what I want is to narrow down the entry options for the sale to only those recipes that where baked that day of the Batch the user selects.

I have try different options and angles using lookups and selections but haven’t been unsuccessful on it. I’m kinda new on this type of selections.