I figure I should know this already but too much time at the computer today...
I have two tables.  One is being populated with a form.  I need them both to update with the form.  Here is more info (photo to follow):
I have a form to create different custom mixes for clients (hanging baskets).  The form relates back to a MixPlugT so we can use the information to tell the grower what plants are being used and how many (this side is yet to be developed).  Once we make the mix, we then add it to the client's order where the basket size and quantity are recorded.  This form relates to a MixChoiceT with much of the same info.  I would like the MixChoiceT to update when the MixPlugT is changed.  What is the best way to go about this?
Thank you!