Create a single form which is based on several tables

Hi there

I am trying to create a form which does the following:

Thare are 5 categories: School, Community, Family, Peers, Individual.

In each category, there are between 6 and 8 subcategories.

These categories are reviewed on a 6 month interval: Start, and 6 months
intervals later for at least four years.

What I am trying to do is see all of this information on one form.

I tried to put this all in one form but exceeded the limitations of data.

What is the best way to do this?

Thank you for your help in advance.
PS. This is only 1 of several forms in a case management database.

On Fri, 26 Mar 2010 14:40:01 -0700, forest8
wrote:

Hi there

I am trying to create a form which does the following:

Thare are 5 categories: School, Community, Family, Peers, Individual.

In each category, there are between 6 and 8 subcategories.

These categories are reviewed on a 6 month interval: Start, and 6 months
intervals later for at least four years.

What I am trying to do is see all of this information on one form.

I tried to put this all in one form but exceeded the limitations of data.

What is the best way to do this?

Thank you for your help in advance.
PS. This is only 1 of several forms in a case management database.

Are these "categories" tables?

How are they related?

What real-life Entities (persons, things, events) are you tracking?

What's a "review"? What information do you need to record about a review?

My guess is that you're (still... we've been here before) just throwing more
fields into a table: is that your "limitation of data"?

Rather than working on the form... get your properly normalized tables set up
FIRST (or describe them for us).
--

John W. Vinson [MVP]

Hi

I the past we discussed some of this, but this is new.

The results of the data has led to additional information which has to
summarized based on earlier results. While the "categories" remain the same,
the resulting data is different.



"John W. Vinson" wrote:

On Fri, 26 Mar 2010 14:40:01 -0700, forest8
wrote:

Hi there

I am trying to create a form which does the following:

Thare are 5 categories: School, Community, Family, Peers, Individual.

In each category, there are between 6 and 8 subcategories.

These categories are reviewed on a 6 month interval: Start, and 6 months
intervals later for at least four years.

What I am trying to do is see all of this information on one form.

I tried to put this all in one form but exceeded the limitations of data.

What is the best way to do this?

Thank you for your help in advance.
PS. This is only 1 of several forms in a case management database.

Are these "categories" tables?

How are they related?

What real-life Entities (persons, things, events) are you tracking?

What's a "review"? What information do you need to record about a review?

My guess is that you're (still... we've been here before) just throwing more
fields into a table: is that your "limitation of data"?

Rather than working on the form... get your properly normalized tables set up
FIRST (or describe them for us).
--

John W. Vinson [MVP]
.

On Fri, 26 Mar 2010 20:40:01 -0700, forest8
wrote:

I the past we discussed some of this, but this is new.

The results of the data has led to additional information which has to
summarized based on earlier results. While the "categories" remain the same,
the resulting data is different.


I'll be glad to try to help if you'll answer my questions.
--

John W. Vinson [MVP]