Hey,

This may sound weird, but I wanted to verify that I had my tables and relationships set up correctly before going any farther. Any feedback would be great!

Thanks,
Kat

Kat,

Without knowing your data model, the relationships appear to be ok
Would advise against using symbols--*#, etc in your field names
Would also advise against using spaces in field names--
both can cause isses later in queries and vba.

A good way to know if relationships are correct is to create a form/s & enter some "dummy" data.

HTH

Thanks, I'll give that a try!

kat

Hi Kat,

Understanding the relationships relies on the knowledge of the business process behind the database model. Since we do not know anything about your business process, we can only guess if your relationships are correct or not. For example:

Is it true that all vehicles assigned to, say, "Division A" could have a different Division POC? Or, does Division A supposed to have only one POC? If the latter, then your relationship does not reflect that.

Just my 2 cents...