Hi,

I have one database where you enter the date a session started. In another database I enter the date of the treatment.

Since I have patients who started already several different sessions, I want to create a portal in the sessions database which is showing me only the treatment dates starting with the date on which the session started.

I know it looks a bit difficult (English is not my native language - sorry!), and I am sure it can't be that difficult...but i need some help.

Your help will be appreciated!

In order to understand your problem can you tell us how the relationships are organised?

For every patient there are many Sessions?

For every session there are many treatments?

If we understand this it will be easier to help you.

Search the Forums for "smart ranges"