Forum Home
Press F1
Thread ID: 14442	2002-01-09 00:03:00	MS Access question	Guest (0)	Press F1

Post ID	Timestamp	Content	User
30353	2002-01-09 00:03:00	I run a simple access customer database. In a form I enter customer details which are written to a customer details table. Within the form I enter name, address etc. At the suburb field I get a drop down menu of all the suburbs (held in suburb table) then at the Town/City field there is another drop down menu for the city. How can I make it so that when I select the suburb the correct city is automatically entered into the city field of the form? So if I enter Riccarton Christchurch automatically appears in the City field and if I enter Mt Eden then Auckland automatically appears in the city field. How do I link the tables to do this?	Guest (0)
30354	2002-01-09 00:32:00	Dunno	Guest (0)
30355	2002-01-09 03:46:00	Dave Try making a 'Suburbs in City' table. In other words, a table with 2 columns; column 1 = suburb, column 2 = city. Fill in the table for all suburbs in the suburbs table. Link the suburb field to the suburb field in the suburb table, and the city field to the city field in the city table using the Relationships form. Change the form in question so that the combo box (or list) refers to the 'suburbs-in-cities' table instead of the 'suburbs' table. You can now reference the correct city in the appropriate text box on your form. If you have a problem, drop me an email (ray.anderson@xtra.co.nz).	Guest (0)
1