PC Review

Thread Tools Rate Thread

Inventory and Invoiveing- Followo for Steve Schapel

Posts: n/a
      28th Oct 2003
Hi Steve,

I did create an invoice table with feilds as :
InvoiceNumber (a code is used to generate invoice numbers)
primekey, CustomerName, and InvoiceDate. Another table,
tblTransaction, has PartNumber, PartDescription,
UnitsPrice(comes from another table), etc.

frmInvoice is continous and frmTransaction is now a
subfrom on frmInvoice. There is an error with duplicate
prime key. I guess my question is, whta must be the Prime
keys for these two tables? I have AutoNUmber as the
PrimKey to tblTransaction and InvoiceNUmber as the
PrimKey to tblInvoice.


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
.....Hey Steve Schapel...! Popparod Microsoft Access Queries 6 12th Dec 2004 08:27 PM
Steve Schapel: Linked fields error =?Utf-8?B?ZG9nbWVsaXNzYQ==?= Microsoft Access Forms 0 10th Nov 2004 06:33 PM
To Steve Schapel, another question? Sandra Microsoft Access Forms 2 31st May 2004 07:49 AM
Inventory - Followup for Steve Schapel please Mike Microsoft Access Forms 0 28th Oct 2003 03:33 AM
Disabled tab control (Steve Schapel?) Omar Microsoft Access Macros 0 31st Jul 2003 02:20 PM




All times are GMT +1. The time now is 12:44 PM.