Setting to allow duplicate company names in a contact management DB

[orlando2002]

Hi,

In a contact management DB I want to be able to record the addresses of a number of contact people and braches of the same company. In other words, a company has several branches and I want to record their different street addresses. What settings do I need to specify in the field "CompanyName" or elsewhere?

Another question is how to set a Text box, especifically "CityName," so the name of the city fill out the text box when I start typing the first letter of the city name but without using a predefined list of city names.

Thank you for your help.

Orlando

 

[KeithIT]

You need to create a unique indentifier as your primary key for the table with the companyname field so that you can have more than one company with the same name. The other option (and perhaps the better one?) is to have a table with company names, a table with addresses, and a third table linking them. This takes a little longer to set up but will make things much easier on you in the future when you are trying to update the information in any of the tables.

in order to have a text box automatically fill in the city names you have to be working off of a predetermined list of city names, otherwise the db has no place to get the information from. You can check out the USPS site, they have some great vb code for filling in city and zip code fields and for checking the data (you must have an always on internet connection for these modules to work), or you can check this forum for information on adding records to a combo box. That's the way to go with this particular field.