However, one main power of RDBMS is that data does NOT need to be stored in several places.  As I see it, if I want to have data from 2 forms in 1 view, I need to add a lookup field, this distorts a little the logic of dividing the data.

However, I will ask a question, and hopefully, it's possible:

Each of us has many tables/forms, some of the objects are more core objects (person, ID...), while other are data decsribing - name, address, email...

If I have data that is stored in several forms (other reference tables that hold other links/relations to other objects) how do I display somekind of a summary (Most related to as a Master-Detail) table, that can be changed via the master object drop down.

And I mean something like this:

I will have the main object (lets say : name) as a drop down menu.

When I change/select a new name, all the informatio on view will updated, and I will see only data that is related to that name.

That data is retrieved from several forms
- 1 form can be contact details

- 1 form can be medical treatments this person/name had (can be more than 1 entry)

- 1 form can be chat history made by a representative with that person/name (can be more than 1 entry) 

The data of the relational forms is stored in a different form (forms) and I need to know how to pull it.

thanks,

Saar