I am trying to make a call log page ([login to view URL]). What I have is 2 rows in 2 different tables, Banks and Contacts. The first table is the Banks Table. I have a BankName field which I want pulled from the database and loaded into a drop down box (Select BankID,BankName FROM Banks). When the user selects a bank I want to have a second combo box which will update to show the contacts for that particular bank from the contacts table (ContactID, BankID, Contact). The BankID is the primary key and foreign key for the tables to determine which contact belongs to which bank. I want to have this page post to a different page ([login to view URL]) that will just be a [login to view URL] [login to view URL] to display the combo values (Bank,Contact) and the multi-line Text Box and that is all on that page. I am including my bad code which I have, which includes a ModelID field in the contacts table which I want removed but should give you an exact idea of what I want. I also want the drop down boxes to be static in size at 20 characters so the second doesn't resize.
## Deliverables
1) Complete ownership and distribution copyrights to all work purchased.
## Platform
ASP/Access 2000