Hi everybody and thanks in advance for the answers.
A customer asked me to migrate his contact book, actually made with access, on sugarCRM.

The problem is this: the db has a main table with the contacts, and yet a series of sub-tables that might be as simple as dropdown menus or instead tables with much higher complexity (whereas town, province, number are reduced to just a single value)
How can i transform such subtables in something i could link to the contacts table? with a module? how?
is it possible to think i might implement autocompletion so when i start writing the name of a street the rest of the names appear?...

thanks in advance for your help