Good, that is what I currently have set up. The main OrderT is linked to fk_BudgetID which works fine, but linking a secondary budget is creating a problem. Do you think my solution of a yes/no (shipping) box in the OrderDetailT is a good route for handling the cases of shippings? Where would you put the expression to show this amount later on because if shipping is (true), you would not add to total.
For example, Total = Sum(Subtotals), Shipping = Shipping Box, Final Total = Total+Shipping
Or do you think there is an easier way to pull shipping totals? Either way, shipping would need to be a line item in this case, with my line item range being 1-10.
Thank you!

---

Reply from Richard Rost:

Yes if you need to do it this way, having shipping as a line item is fine. I thought of building my database that way in class, but opted not to. Shipping as a line item also works if you have partial shipments because you might have multiple shipping charges.

You could do two totals in your form footer - one for shipping items and one for non-shipping items. You could even make "shipping" a category like we talked about earlier and just add up items in that category.