AnsweredAssumed Answered

Table Occurrence depending upon field contents

Question asked by Dave_1 on Jul 30, 2012
Latest reply on Jul 30, 2012 by philmodjunk


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.