Re: Revision Control

operationsengineer1@yahoo.com......

So you have three tables:

> T product_base
> T revision
> T product_revision

I don't understand the difference between revision and product revision.
Maybe product_revision is a cross reference of the first two tables?

What kind of queries would you make?  I don't really see the sense of
asking what products have a revision 4.  What are these products anyway?

Maybe it would make sense to ask who uses a product a revision 4 level,
but you don't have a users table.

I think we need more info as to what you are trying to do.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================