Richard, I've watched the 300 series videos a few times and have a question. If I had a budget in place for my order(s), (($500 for supplies) ($100 for mailing), and ($100 for shipping cost)), how would you set up a table and relationships for this? OrderT, OrderDetailsT, and BudgetT I am assuming. So on the particular order I want to spend $50 on supplies (one budget amount) but there is a $5 dollar shipping cost charge (another budget amount), how would you set this up? It sounds crazy to seperate the two (normally it would fall in the same), but for my company we seperate them. Could you get away with a yes/no box and later define yes=shipping budget?

---

Reply from Richard Rost:

What I have done in the past is to set up a Budget Category table and then place each ITEM in a category (office supplies, shipping, computer hardware, etc.) then you can calculate an exact cost against your budget for each category.