Working with multiple tables
<p>Hello, I'm a forum member that has 2 years of crystal experience (OJT). I have an issue which I'm sure is quite simple but I can't seem to solve.</p><p> I have 3 tables in one database:</p><p>1. ORDER_MASTER with fields of BRANCH, ORDER and SERIAL_NO</p><p>2. PRODUCT_ORDER with fields of SERIAL_NO, STATUS and DESCRIPTION</p><p>3. ADDON_ORDER with fields of SERIAL_NO, STATUS and DESCRIPTION</p><p>I link 2 and 3 to table 1 by SERIAL_NO. Fields STATUS and DESCRIPTION have similar values and syntax. I'd like to be able to extract STATUS and DESCRIPTION data for both tables with use of a single field.</p><p>In simpler terms, PRODUCT_ORDER may have 3 records with SERIAL_NO 1 and ADDON_ORDER may have 2 records with SERIAL_NO 1 and I'd jsut like to be able to get a simple list of all 5 records each on their own line.</p><p> Hope this makes sense and thanks for your help.</p><p>Carl</p>