>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

you'll be using combo boxes for this -- set the control source for each combo to the network table. use something like "select * from allcodes where codetype = [vendor]" for the recordsource...

good luck...