PC Review


Reply
Thread Tools Rate Thread

Inventory and Invoiveing- Followo for Steve Schapel

 
 
Guest
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.

Reards,

Mike
 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:46 PM.