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!
May 18 2012, 10:13 AM
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.
May 18 2012, 10:14 AM
Thanks, I'll give that a try!
May 18 2012, 10:15 AM
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...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.