By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,650 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,650 IT Pros & Developers. It's quick & easy.

Relationship Question:

P: n/a
Hello,

I have 6 Tables.

I want to have same primary key for all the records...

Is that possible?
Thanks

Balaji

Aug 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes, it's possible. One tabe has a primary key (autonumber). the rest
have a long integer field that's set to unique. then you can do a 1-1
join.

Do you have an entity with more than 255 fields? If so, why do you
need 6 1-to-1 relationships? Why not just put all the fields in a
single table?

Aug 3 '06 #2

P: n/a
ba**************@gmail.com wrote:
Hello,

I have 6 Tables.

I want to have same primary key for all the records...

Is that possible?
Only if they all have a one-to-one relationship which would be very unusual.
One-to-ones are a bit rare to begin with and that's just with two tables.

Explain your data.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.