right, im designing a database to manage all files and documents for a company i work for, my database consists of:
Tables
Stock Controller (main)
Exceptions
ISOS
Waste Disposal
Driver Ctrl Forms
Postcodes and Boroughs
Forms:
Stock Control
Exceptions
ISOS
Waste Disposal
Driver Ctrl Forms
now, the problem i have, in the stock control form, it has these fields:
ID
Collection Number
Date
Postcode
Town
Borough
Item
Weight
Qty
Comments
what i want to acheive is.. when i type in a postcode, say "SE18" on the stock control form/table i want it to recognise that as a postcode from my [postcodes and boroughs] table, and so, as a result, recognise that "SE18" from [postcodes and boroughs] belongs with "Woolwich" from [postcodes and boroughs] and "Greenwich" from [postcodes and boroughs] and then automatically completes the "town" and "borough" fields on my form as soon as ive completed the "Postcode" field,
BUT!!
the tricky part is,
1. i want it as a typing autocomplete, not a dropdown box
2. i want to be able to type "SE18" then it completes the rest, and then i can continue to write "7NB" to finalise the postcode..
3. i want to be able to link this with the [exceptions] Form/Table, and [Waste Disposal] Form/table so that it autocompletes on all Tables/Forms with a "postcode" "town" and "borough" field..
Screenshots:
Stock Control Form:
http://imageshack.us/f/823/formv.jpg/
Postcodes and Boroughs Table
http://imageshack.us/f/411/postcodes.jpg/
and the Stock Control Table:
http://imageshack.us/f/266/stockm.jpg/
Any Help or suggestion is GREATLY! appreciated.. thanks