shreyans.ghia
Registered User.
- Local time
- Tomorrow, 03:22
- Joined
- Jun 2, 2013
- Messages
- 12
Hello,
This is my first post on this forum. Hence in case i have missed out on guideline re posting messages, excuse me for the same.
I needed some help re Composite Primary Key in Ms Access 2010. I shall try and explain my tables in detail. So my first table is "Client Database" where the field "Buyer" is primary key. This is connected to my next table "Project Database" which has fields such as Work Order #, PO #, PO Date , Buyer etc where Work Order # is the primary key. Finally "Projects Database" is connected to Order information. Now the problem is until now, I always had 1 PO # for each Work Order #. However now I am facing a situation where my client has clubbed multiple PO #'s for the same Work Order #.
From what I understand to solve the above issue I need to trigger the Primary Key Violation only if both the Work Order # and the PO # are the same.
Hence any help on the above would be highly appreciable.
Thanks in advance.
Shreyans.
This is my first post on this forum. Hence in case i have missed out on guideline re posting messages, excuse me for the same.
I needed some help re Composite Primary Key in Ms Access 2010. I shall try and explain my tables in detail. So my first table is "Client Database" where the field "Buyer" is primary key. This is connected to my next table "Project Database" which has fields such as Work Order #, PO #, PO Date , Buyer etc where Work Order # is the primary key. Finally "Projects Database" is connected to Order information. Now the problem is until now, I always had 1 PO # for each Work Order #. However now I am facing a situation where my client has clubbed multiple PO #'s for the same Work Order #.
From what I understand to solve the above issue I need to trigger the Primary Key Violation only if both the Work Order # and the PO # are the same.
Hence any help on the above would be highly appreciable.
Thanks in advance.
Shreyans.