AutoFill Fields on a Form

[james7705]

I have a table (tblCustomers) with Fields - ID, FName, LName, ContactNumber, EMailAddress, Street, Suburb, City. The fields Street, Suburb and City get their values from another table, (tblReferenceData) with Fields - ID, Street, Suburb, City. Should I be using a lookup and relationship field on my table or should I use a query to fill my tblCustomers



On my form I would like to select the street on a combo box, the suburb and city must autofill. How do I do this? Do i use a DLookup Function and how do I do that. Don't know anything about it. I only have macros and expressions on my database.

[ranman256]

1 field I may used dlookup
many fields, query.
The update query would get the id on the record you are editing, and update if from the [suburb] key in the other table.