Search results

Thank you Isskint, but this doesn't do what I need. This query simply pulls up a list of paired values: BatchID, LotID I should have mentioned that there are multiple lots of each supplement and what I need is for the user to be able to choose the appropriate one. So I was looking to make a...

I'm making a database that helps keeping track of particular lots of ingredients going into certain recipes. The relevant tables are tblSupplements (SupplementID, SupplementName) tblSupplementLots (LotID, SupplementID, ArrivalDate) tblRecipes (RecipeID, RecipeName) tblRecipeItems(RecipeID...

I'm relatively new to Access and DB development. I'm a mathematician by training, making a db for Mushroom farming friends. I live in the sparsely populated state of Maine where the weather is still winterly and the bookstores have few books on databases.