>>
>>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...
>
>Ok, that makes sense. So do I have to create my relations in either the database or form data environment before setting the control/record sources on my forms? If yes, how? And do the field names have to be identical for relations, i.e. does network.dbf have to use field "codeno" for the dispvalue codeno's? And if yes, how do I get around the fact that I have multiple code fields in one table (network.dbf has codes for vendor,o.s.,protocol and topology)?
>
>Thanks!
>Mandy
no relation in the dbc or in the form de. each code field will essentially be working with its own 'code table' (the select statement to pick valid codes, descriptions for field). field names don't have to be identical...