Khalid-
Sorry about the name mixup!
Collection Voucher *should* have a Primary Key. I assume that CartonNo starts over at 1 for each new Consignment, correct? If so, then the combination of Consignment Number, CartonNo, and Suffix should make a valid Primary Key.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 20, 2014, at 9:26 AM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
By the way i'm Khalid not Robin, but its OK you might be replying to many people so it happened.
The table in question is CollectionVoucher which has no Primary key, there are some fields in this table which are Primay key in their own table.
table Consignment Number has ConsignmentNo as Primary key
table Clients has ClientCIN as Primary key
table Consignee has ConsigneeID as Primary key
Khalid
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar