Combining Primary Keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to track product that comes in under one purchase order, has three
seperate sizes, and can be processed on either 1st Shift or 2nd Shift on any
day during the week.

I would like to be able to sort and analyze my data based on purchase order,
size, and which shift processes the product.

Can I make the combination of each of these elements into the "Primary Key"?
 
You can. It's called a Compound Index and it doesn't need to be unique or a
primary key, but can be it you want to. To set it as a Compound Primary Key,
Drag the fields to the same area, select them and click on the Key icon.

Then open the Index dialog and look how it is entered. You can duplicate
that manually for any other index as well.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reporting Database - Help with Primary Key 1
Adding a primary key 3
populate time field based on field 8
calculating using the IIF statement 1
Assigning shift to Time Intervals using IIF 6
primary key - concatenated or autonumber? 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Combine two field’s into a third field as a default value 2

Back
Top