Hi!
I think I can help.
But first i need to know if your working with FORM or REPORT.
Claire M. cmarcoux_at_webnet.qc.ca
Jasper <jasper_s_at_email.com> a écrit dans l'article
<369382CF.31E61A8_at_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 - 17:30:43 CST
