I am using MX2004|ASP|Access. Trying to create an input record form using linked tables in Access. The main table is called Data. It contains some text fields as well as a field called BreedID. BreedID is a numeric field that is linked to another table called BreedList. BreedList contains the BreedID field as well as a BreadName field. In Access, the tables are linked such that the user can choose the breed name from a combo box. I would like to duplicate that on the website using a list box. Hence, the user would pick the breed name from the list box, and then the associated BreedID number would be added to the new record in the Data table.

Thanks for you help.