(newbie) relational database creation problem

From: Jasper <jasper_s_at_email.com>
Date: Wed, 06 Jan 1999 15:35:43 +0000
Message-ID: <369382CF.31E61A8@email.com>

Hi,

I'm not sure if this is the appropriate newsgroup to post in, but I couldn't find any other newsgroup more suitable.

Here's my problem :

I have 3 tables : articles, systems & orders. When entering data in the orders table, I want to be able to select from both the articles and the systems table, so that it would be possible to create an invoice like this :

Mr. X

Article No.   Quantity  Description             Price  Total  
  11427           3     Diskdrive 3.5"           $20    $60
  21523		 10     40x CDROM                $70   $700
  14623           1     System No. 25143        $1499  $1499
                                                       ----- +
Grand total                                            $2259

How can I get this done ?

Many thanks for any help !

Jasper

Red Hat Linux - Kernel 2.0.36 on an i686 grep... grep... grep... (frog with unix stuck in it's throat) 4:18pm up 17:53, 0 users, load average: 0.25, 1.08, 1.51 Received on Wed Jan 06 1999 - 09:35:43 CST