primary key

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ruth - 23 Jan 2008 01:42 GMT

I have a data base and I want the primary key to be a combination of several
columns, ei 1. date and time, 2. scac code, 3. vessel code, 4. trip code

Is this possble? If so, how is it done, if not - any suggestons?

Signature

Thank-you!
Ruth

Reply to this Message

Rob Parker - 23 Jan 2008 02:07 GMT

Hi Ruth,

It's possible, and easy ...

Select the fields you want for your PK in the table (opened in design view),
by control/shift clicking in their record selectors. Then either click the
Key button (with an icon that looks like a key) on the Table Design toolbar
(by default, in A2002, it's about in the middle of the toolbar), or select
"Primary Key" from the right-click menu.

HTH,

Rob

>I have a data base and I want the primary key to be a combination of
>several
> columns, ei 1. date and time, 2. scac code, 3. vessel code, 4. trip code
>
> Is this possble? If so, how is it done, if not - any suggestons?

Reply to this Message

Ruth - 23 Jan 2008 14:28 GMT

Thank-you very much!

Signature

Thank-you!
Ruth

> I have a data base and I want the primary key to be a combination of several
> columns, ei 1. date and time, 2. scac code, 3. vessel code, 4. trip code
>
> Is this possble? If so, how is it done, if not - any suggestons?
>

Reply to this Message