I have the following tables town, street, postcode, which are linked.
What i am trying to do is in a form when someone enters the post code, the street and town for the post code would be displayed.
Or if someone enters a town, only the streets + Post codes for that town are displayed.
Im sure there is a way to do this using SQL, and would appreciate help!!
Jon
What i am trying to do is in a form when someone enters the post code, the street and town for the post code would be displayed.
Or if someone enters a town, only the streets + Post codes for that town are displayed.
Im sure there is a way to do this using SQL, and would appreciate help!!
Jon
