Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asp__developer
Posting Yak Master
108 Posts |
 Posted - 2013-07-12 : 13:23:49
|
| I am trying to build a web page based on this configuration: [url]http://alturl.com/he7b8[/url]As you can see, based on selection of rows from first tab1 (bases), the other values are displayed in tab2 (poles).Now, based on that combination of bases and poles, tab3 shows Platform and based on all combination tab4 displays docking and so no...Right now I only created 1 table something likeID (PK - Incremental), port#, descp, msrp, imageNow I don;t know how to go forward since I need result based on combinations...can anyone please help me out in designing the table structure for this configuration ? How many tables I need and how I will link those tables ?Also, in the configuration page, you can see "Recommended Solution" if you select anything. It changes as you go forward with your combination - how to implement this also ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-13 : 12:10:51
|
| you need to setup foreignkey relationships between tables to filter one data based on other tables selection------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Need help with tables for combination based result