chrisandclaire

Thank you so much for all your help - I've been working on it since you posted and I've finally just cracked it. Your help and the demonstration file made all the difference. Thank you for taking the time :)

hi, thanks for that. I think im almost there. I have 2 tables, one: Recipes two: Ingredients (which contains a cost per gram field) I have my recipe layout set to display 10 drop down boxes from which you can pick ingredients from the ingredients table I have set a relationship between (recipes) ingredient 01 = (Ingredients) Ingredient name I then set up a field on my recipes layout which displays the "cost per gram" data from the record in my ingredients table I can get it to work for dropdown one, eg I select cocoa butter from the list and it changes to display the correct cost but I can't for the life of me set up dropdowns 2-10 to do the same. Any ideas? many thanks :)

my dropdown is currently a static list of ingredients

hi guys, Please go easy with the noob! Im creating a database which formulates recipes. I have created drop down lists for selecting the ingredients from and a value list containing ingredients, what I would like to happen is have a user select an ingredient and then have my database automatically show the cost per gramm of including it in the recipe for example, when sodium bicarbonate is the ingredient selectedfrom the dropdown, I want the database to automatically then display the cost in a field next to it. Any ideas as to how I can link the value list in such a way? any and all help would be greatly appreciated. thank you in advance, Chris