search for: orders_status

...#39;' orders and can ''Purchase'' the order I realize this is more of a workflow question, but I''m trying to figure out the best way to structure this. Here is one thought... Statuses Table ---------------------- ID Name Orders Table --------------------- ID Name Orders_Statuses -------------------- order_id status_id Then, I can do a join in the model to only return the correct rows. Is this the correct way to do this? Also, what type of logic should I be doing in the controller (i.e. Making sure that the Order is approved and submitted before Purchasing can order it...