Help with relationships and design

[James Bailey]

I'm developing a temporary access database to enter services. I'm really hung up on one part - How to enter Service Companies, and Places (place of service).

I've already got about 50 records entered into the current database. My Places are already getting duplicated because there are multiple service companies in that city. For instance, Bordeaux, France has four different PlaceIDs because of four companies that we use there.

Does my design look logical? I just get the feeling I'm doing something wrong and can't quite put a finger on it. I think that Bordeaux should have one ID and each company associated with that city would have it's ID.

I use cascading combo boxes on my form. When a user selects a service company, the next combo box queries for all of the cities that the company is located in. When they choose the city, the country is automatically filled in.

Is there a better way I could design my tables?

 

[James Bailey]

Well, for better or worse, I decided to change things around a little bit. This will keep service companys and places from being duplicated. It got so bad that my countries were even being duplicated in the old design.

Here's the new one. It seems to be working ok so far. The new table (ServiceCompanyPlaces) contains nothing but numbers...

Any thoughts?

 

[James Bailey]

I learned a lot about data validation today. Multi-field indexes are very handy for what I'm doing. I still don't know if my design is very good but at least the data isn't getting to far out of whack.