Three fields as PK problem

[rukk]

Hi,
I have a problem with a small database that i have created. I do need to run a query to retreive the information from three tables(data will be imported into the tables through .txt file). Those tables are

tblCoupon: CouponId,CouponVersion(as PK)
tblCommunication : CouponID,CouponVersion,CommID (should be PK)
tblOffer: CommID(PK)

In the above tables the tblCommunication should have those three fields as primary key. But in the tblCommunication as it is getting imported from .txt file it has an order to get imported, and its order is CouponID,CouponVersion,BundleID,CommID, where BundleID is a PK for tblBundle which i don't want in this query. When i try to set the primary key by pressing the shift key and moving down, i can't able to skip the BundleID to go to CommID. How to set this Primary key in Access2000.
I have tried to run this query with out specifing the PK then i am getting all the information for only one CouponID.

 

[psemianonymous]

You can click on the lightning icon, which brings up the "Indexes" dialog box, in which you can set up your primary key without the whole highlighting business,

OR

you can use CTRL+click to highlight all three fields.

 

[rukk]

Thank you