Recent content by Kovenna

Thanks DBGuy, No, I have set up the ingredients to have 1 UoM each, and only 1. I'm guessing I make the Recipe Line table column Ingredient_ID a "Lookup" tyype column which references the Ingredients table where RecipeLine_Ingredient_ID = Ingredients.IngreientsID something like that?

I am trying to create a small database system that will produce a week's shopping list for food. I have a recipes table, then a Recipe_Lines table, then an Ingredients table and finally a Unit of Measurements table. I have a form to "Add a Recipe". The control source for this form is the...

Hi TheDBGuy, Thanks for your response;) Most odd..now that I check it again, the properties are there as you say. Oh dear, can't explain it. But thanks anyway!

I have a form that I use to allow users to Add/Amend/Delete accounts (Chart of Accounts). I have inserted a listbox on the right of the input fields so that as an account is added/updated the user can see the effect on the whole table. So far so good. However, as the user adds accounts, the...