Question What is the best way to display multiple fields from multiple tables?

[SimonSezz]

I updated the zip file with the latest database. Also here's a picture of the relationships in case you don't want to download the database:

One thing I don't know with the relationships is how to link "tblPlans"... it contains all of the plan types that are available. Does it even need to be linked to another table?

 

[RainLover]

Your Autonumber should be the Primary key which links to a Foregin Key in another Table.

IDs should be named like EmployeeID, DependantsID etc.

Your table tblPlans should also have a Primary Key of Autonumber not the three fields that you are using.

You have repeating data. Especially, PlanType, PlanCategory and CoverageType.

Why would you have EmpName in tblBillingBalance when you already have that information in tblEmployees.

Hope this helps.

 

[Pat Hartman]

The autonumbers should be the primary keys and they are the values that will be used for all relationships. However, if your business rules state that some field or combination of fields must be unique, you need to create a unique index to enforce the business rule.

 

[SimonSezz]

Alright I think I'm starting to understand the whole relationships principle. I can't believe I find this so difficult when Java/C programming seems relatively simple to me and I have been doing it for years.

Here's an update (and thanks for all of the help guys):

 

[RainLover]

It would be nicer to have the Primary Key and Foregin Key to have the same name.

tblPlans?????? Why do you not follow the same rules.

Think about what Pat posted.

 

[Pat Hartman]

Designing a database is probably something you never did as a Java/C programmer. It is a totally new skill and it should give you more respect for what Access developers do since they must wear many hats to produce successful applications. A Java/C programmer implements the design created by someone else and gets his data from a database designed and created by someone else which isn't to belittle the skill required to program. Programming is simply one of many skills required of a professional Access developer.