Table Design Help..........I think

[kentwood]

Have a database that I am working on this is constructed to perform Compliance tracking of wellness activity by employees. Have all my tables, queries and a form that has 3 tab controls as well as a subform on one of the tabs.

It is necessary to create a quarterly report card based on 6 wellness cateogories that have specific criteria. I thought I was OK but now I am having difficulty pulling it all together on the report. I now think that it has to do with my table construction and I am looking for advice. If there is someone I could send my DB to who can take a look and give advise or assistance I would greatly appreciate it. Thanks.

 

[spectrolab]

Hi Kentwood,

It might be better for you to post your db here and let everyone have a look at it (removing anything confidential, of course) instead of trying to send it to some one. Probably best to compact it first, using utilities, and zip it before posting.

 

[patrickcre8]

You can link all the tables in the form or report by ID as well.

 

[kentwood]

I am attaching my DB that I have compacted so you can get an idea of what I am trying to do. In the tables, you will see one called Test that consists of fields I think I need to get the report to work out right. The Compliance report is also there to show you what I need but each report will need all 6 measurable items listed, some that may have an NA in the criteria field. We will be notified a bit later as to what each member/spouse is required to meet. I think I may be a bit over my head on this as I am still considered somewhat of a newbie but it does help me learn as well.

 

[patrickcre8]

Hope this could help.

 

[kentwood]

Prior to leaving for work, I am quickly trying to see what you did. The Compliance report is now populating as it should but as I look at my compliance form, the thrid tab for Compliance is not visable. Also, it appears that the form cannot be used to add new entries at this time. What are your thoughts? Were my tables OK to leave as they were?
Thanks.

 

[kentwood]

When got to work to try it, the compliance form worked very well and the 3rd tab was viewable. Based on what you have seen in the database, does this seem to be built in a manner that is most efficient? Is there any way that my report card form can be built in such a manner that all fields they are measured on are visable (Category, Criteria, TimeFrame) and as events take place, the blanks to the right of them (CriteriaMet and Comments) will be populated? This is where I thought maybe my table design was wrong.