relational database design, simple question!

[gerard1979]

I have a table with several fields.
3 of them are followed_by, written_by, asked_by. All three fields are comboboxes and refered to the same tblUser.
Make it a difference to take 3 tblUsers in the grid and build 3 relations between them or take 3 lines from 1 table to the three fields?

gerard

 

[LittleSmudge]

All three fields are comboboxes
No. FIELDs are in TABLES
COMBO BOXes appear on FORMS

Do you mean you have BOUND Combo Boxes to these Fields on the Form ?

in the grid
What's a GRID ?


If you are talking about the Relationships Window then you'll find that Access will display it as three seperate table regardless of which way you try to draw it.




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[JeremyNYC]

Gerard,

Sounds like you are building a query on which to base a form. If that's the case, you actually don't need any copies of tblUser in the query, you just want to pull those three fields over. Then, in the form, when you build the combo boxes, each one of them is a lookup to tbl user.

Oh, on the other hand, maybe you're doing this for a report. If that's the case, then yes, it does make a big difference. You'll want to use three different copies of the table.

If I'm off base here, get back with answers to some of the questions from the other post.

Hope this helps.

Jeremy =============
Jeremy Wallace

http://www.AlphaBetCityDataworks.com

Designing, Developing, and Deploying Access databases since 1995.