I have set up 15 different sizes/ styles of hanging baskets for options for my customers.  Each of these is given a size rating of 1-3 for my grower.  The size rating gives him information on how many plants go in each basket.  I dont show the size rating on the customer side of things as it just complicates things.  I have added a field on the OrderDetailT that can that information to be 'farmed' out in a query for the grower.  Since I dont have any input for that in the order side of things, is it possible to have Access automatically fill in that field baded on the BasketStyle Field?  If so, how would I go about this?