relating two fields to the primary key

[atadbitslow]

I have table A with a primary key autonumber field. In table B, there needs to be two fields (field 1 and field 2)related to the primary key in table A. Is this possible?

Thanks! Excuse my confusion....it's only temporary......

 

[KornGeek]

Yes, just set the data type of the fields in Table B to Long Integer. It should work easily.

 

[JeremyNYC]

Why do you say you need two fields related to the other table's PK? They will be identical. What are you doing with the fields?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[KornGeek]

Actually Jeremy, they wouldn't necessarily be identical. For instance, imagine an Employee table with 2 department fields (to allow Employees to work in more than one department). Each of the two department fields would be related to the primary key of the Department table.

 

[JeremyNYC]

KornGeek,

That would be very poor database design. The proper thing to do there would be to have a lookup table to facilitate a many-to-many relationship. Otherwise it's gonna be a real drag when some hotshot starts working in a third department.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[KornGeek]

Jeremy,
I'll agree that it might not be the best design, but there are some other circumstances where it might be appropriate. (None come to mind, but I'm sure there are some.)

 

[jebry]

I'm biting my keyboard even as we type!!!

Jeff Bridgham
bridgham@purdue.edu

 

[JeremyNYC]

Move along folks, there's nothing to see here... =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[Darrylles]

Hi AT,

What are the 2 fields called?
And why do you need these 2 fields? How are you meaning to use 'em?

We can go from there.

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."