Table Occurrence depending upon field contents
Excuse my newbie-ness, but sometimes this stuff just gets more confusing the more you start to understand it.
Here's my issue:
I've got 3 tables: Classes, ClassOrders, Orders
Classes::Class# = ClassOrders::Class#.
ClassOrders::Order# = Orders::Order#
(The ClassOrders table is an interim table that lets me have multiple classes per order.)
On an order, I will need to cancel a class, but have it show up on a "Cancelled Classes" portal on the Orders layout. So, I want to delineate between a "classOrder" that's valid, and one that's cancelled. I'm not sure of the best way to do this. Any help is greatly appreciated.