i want to create a form where the user can choose from a list of names
in table A
associated with this name is a telephone and address
on the form there will be a drop list for the name, fields for address
and telephone and a comment section
i would like the form to fill in the address and telephone
automatically once the name is chosen, (the only field the user can
actually enter anything into is the comment section) the information in
the form will be saved to table B
getting it to select the name from table A is easy, but how do I get it
to automatically enter the associated information for the other 2
fields
thanks