Foreign Key?

[Excel Is Evil!]

I need to use the Foreign key along with the primary key to create a relationship table...
I know how the primamry key works, but where the heck is the Foreign key?!?!?!

 

[Anne Troy]

It's right in the help file:

How do relationships work?
In the previous example, the fields in five tables must be coordinated so that they show information about the same order. This coordination is accomplished with relationships between tables. A relationship works by matching data in key fields — usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, employees can be associated with orders they're responsible for by creating a relationship between the Employees table and the Orders table using the EmployeeID fields.

Let me know if you can't understand it, I'll be happy to try to explain better.

 

[Excel Is Evil!]

Dreamboat,

Thanks for replying, I understand how they(relationships) work but how do I put it into the table? Like the primary key, you click it and it sets it, but how do I "set" a field using the foreign key? I checked help but there is no explanation for where the actual "key" is located.
Any info would be appreciated.

 

[Russell Hauf]

You don't have to actually set a Foreign Key (FK). A foreign key is just a field that will link to a Primary Key field. Usually, the foreign key can/does contain duplicates.

Dreamboat, what are you doing up so late?

-rh

 

[kredmond]

If you open the table in design view, then click on View and Indexes you will be able to set up indexes on any fields that you want.

Think this is what you mean.

Ken

 

[Excel Is Evil!]

Thanks guys, I thought that you had to actually "specify" if a field was to be set as a Foreign key...