Hi, i am trying to select get data to go into a field when the user
selects data from a dropdown. for example

Table 1:
Name Address
Joe Bloggs 1 No address

Table 2:
Name (Selected by dropdown) Address (I want the address
to appear when Joe is
selected)
Joe Bloggs ????????????

Does any 1 have any ideas. I have tried SQL and Queries but a cant
seem to get it to work, I would app. any help. THX