I have two tables

tbl_1_id_pk
tbl_1_diska_fk (relationship) ---> tbl_2_id_pk
tbl_1_diskb_fk (relationship) ---> tbl_2_id_pk

and

tbl_2_id_pk
tbl_2_name

When I create views/queries for the name for each disk, it returns nothing. Why?

What's the code to your view/query? You're probably not joining correctly to get the results you want.

Never-mind, I was using tbl_2 as a "lookup table", but determined that my views, stored_procs, and queries will just end up a mess.... Plus, using linq2sql turns my ORM into a mess as well. So I figure I will just input the name into the table. Normalization is a pain and sometimes it's not worth it or you end up with MUCK! lol

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.