This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From15/07/1997 09:59:09
Mandy Mccord #011944
Public Interest Breakthroughs, Inc.
Albany, New York, United States
To  
All


Ok, I hit another snafu... I think. I've cleaned up my tables and am trying to update my .dbc with my main data tables and my new code table (which replaced many individual "code"/display value tables). Now I'm not sure how to create the relations between my data tables and the new "code" table which contains all of the display values needed for all of my data tables as was suggested here.

Here's an example of what I've got. One data table collects info on networks folks have in house. It includes code fields for the following data:
vendor code
operating system code
protocol code
topology code
I've got my "allcodes" table whose structure is:
codetype--------->tells the type of code, i.e. vendor, o.s. etc.
codeno----------->the unique i.d. for the display value
displayvalue----->the actual display value for my dropdown lists

Now I need to relate the code fields in the network table to the appropriate fields in the allcodes table, i.e. network.vendorcode to 'allcode.codeno for codetype=vendor' so I can display the proper values in my forms. HELP!!! =8^0

How do I do this? Am I'm doing this right? Any advice would be incredibly appreciated since I think my boss is getting impatient with the length of time this thing is taking and I'm feeling a bit overwhelmed.

MTIA!!
Mandy