After 30 years of marrage Ithought I understood relationships, them I met Access.
I have 3 tables and 3 forms table one is a patients demographics, clientid PK, name, address and such, tbl 2 has clientid (tied to clientid of tbl 1) and medication info, tbl 3 has clientid (also tied to tbl1 clientid ) I also tried tying it to tbl 2 clientid to see if it would help anyway tbl 3 has various health info. Each related form stores the data nicely into each tbl but for the life of me I cannot pull up with a query or report, complete data IE
Bob Smith, address, meds 1,2,3 with a HX of bypass surgery 6 yrs ago. My data is there I just cannot link it. I tried to do it in 1 tbl and I kept getting errors because it was too large.
How can I link these tables to come up with one patient.

Thanks for your help

---

Answer from Richard: The way you should have this set up is a ClientT table, a MedicationT table, and a HealthInfoT table.

Each of your three tables will have a ClientID. In the ClientT table, this is your PRIMARY KEY. In the other two tables, it's your FOREIGN key. I'm assuming each client could have multiple medications and multiple health info items.

To bring it all up together, just create a query and link the tables together using the query designer. If your fields are all named ClientID, then Access should form those relationships for you.

It sounds to me like you need to learn a little more about the basic concepts of building a Relational Database, and making relationships between two tables.

Watch this free tutorial on my web site for help with this topic:

http://599cd.com/tips/access/relational-tables?key=BlFAlEx

I also spend a whole hour in my Access 201 class going over table relationships:

http://599cd.com/site/access/access201?key=BlFAlEx