Compiling several tables into one

Question

I'm trying to create a "master table" to compile client's information from several different tables (ex: insurance, family background, contact info, etc.).  My end goal is to create a printable report for each client containing all their information.  My idea was to run a query based on the clientID primary key and then create the report from the query.

What I've tried so far:

1st attempt

 1) Copied all the fields (in table design view) into one large "master table" 

 2) Set 1:1 relationships between the tables; linked based on a shared clientID primary key

2nd attempt

 1) Ran a query contain all the fields from all the tables (same relationships)

Neither of these ideas worked, the data did not transfer from the individual tables to the desired "master table."

If any one has any ideas, I would appreciate any help.

Thank you.

Answer 1

First, you do NOT need to create a "master Table" here. You can base your report on a query that JOINS all your data. 

Why are you creating 1:1 relationships? It sounds like you may have relational data which would mean multiple tables in a 1:many relationship.

This is what queries were designed to do, join data from multiple tables for reporting and analysis purposes. 

So to help further we need to understand your data structures.