How do you make a foriegn key in access????

[scolivas]

Can some one refresh my memory on how to go about setting up a Foreign Key in Access. It has completely escaped me.

Thanks,
Sophie

[JConsulting]

Can some one refresh my memory on how to go about setting up a Foreign Key in Access. It has completely escaped me.

Thanks,
Sophie

Table2
Table1 ID
ID----------------->Table1ID (ForeignKey)
Data Data
Data Data
Data

[JConsulting]

Can some one refresh my memory on how to go about setting up a Foreign Key in Access. It has completely escaped me.

Thanks,
Sophie

that sure didn't draw right :o)

basically if you have a main table that you consider the ONE in a ONE to Many relationship...it's ID would be used in the MANY table

The main table would probably be an autonumber index field....but in the Many table, it would simply be a number.

Then when you build your relationships, you draw your line from the ID of the main table, to the Foreign key of the Many table.
J

[JConsulting]

Table2
Table1 ID
ID----------------->Table1ID (ForeignKey)
Data Data
Data Data
Data

...........................Table2
Table1 .................ID
ID----------------------->Table1ID (ForeignKey)
Data ...................Data
Data ...................Data
Data

[scolivas]

Figures it is what I have been doing - nomenclature escapes me alot....Thank you so much.