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

tables and relationships

P: n/a
Hi I am trying to create a database. I decided to split some of the
information into two tables (not sure if this is best idea), as some
entries may have these extra information some not.


asset table has information about certain attributes of asset.
system info table has specific information which not all assets will

I linked them via assetID tag its coming up as one-to-one relationship,
it doesn't work how I want it to and I know it should be that type of

Firstly should it be a one-to-more, as not all assets will have system
info. and should I not link the system info table via the primary key

Any help be good

Nov 15 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.