Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

need help in my reference key

2 posts in General Discussion Last posting was on 2006-07-14 03:59:40.0Z
john Posted on 2006-07-14 01:59:41.0Z
From: john <johndalde@biz.phisl.net>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: need help in my reference key
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 203.215.95.78
X-Original-NNTP-Posting-Host: 203.215.95.78
Message-ID: <44b6fa8d@forums-1-dub>
Date: 13 Jul 2006 18:59:41 -0700
X-Trace: forums-1-dub 1152842381 203.215.95.78 (13 Jul 2006 18:59:41 -0700)
X-Original-Trace: 13 Jul 2006 18:59:41 -0700, 203.215.95.78
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5511
Article PK: 1550

Hi i have a preoblem regarding my reference key in my table hope
somebody can give me an idea about this. I have a invoice table, invoice
detail, quotation, quotation detail.

the question is how will i relate the table quotation from invoice, when
we generate invoice it will use the value from quotation.
anybody can give me a good idea about this..

Thanks in advance,

john


Greg Fenton Posted on 2006-07-14 03:59:40.0Z
From: Greg Fenton <greg.fenton_nospam_@googles-mail-site.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: need help in my reference key
References: <44b6fa8d@forums-1-dub>
In-Reply-To: <44b6fa8d@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <44b71521$1@forums-2-dub>
X-Original-Trace: 13 Jul 2006 20:53:05 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 14
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Jul 2006 20:53:07 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Jul 2006 20:59:40 -0700
X-Trace: forums-1-dub 1152849580 10.22.108.75 (13 Jul 2006 20:59:40 -0700)
X-Original-Trace: 13 Jul 2006 20:59:40 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5513
Article PK: 1552


john wrote:
> the question is how will i relate the table quotation from invoice, when
> we generate invoice it will use the value from quotation.
> anybody can give me a good idea about this..

When you generate the invoice, take the quotation's primary key and
stick it into the invoice table (i.e. invoice has a foreign key called
"orginal_quote" pointing at the quotation table). The foreign key can
be left NULL for invoices generated without a quotation.

g.f
--
Greg Fenton
Some Random Dude