Portals and calculations

[bwork]

I have a layout that has thirteen other tables portal over information into the layout. Quick example. Thirteen tables indicating shipping violations. One layout, combines all the information based on the date who shipped. I am trying to figure out a way to get the information for only a month and then generate a report showing how many violations each lab had. Is there a way to calculate a result based on the portals? Thanks in advance,

Brandon

[Ender]

Hi Brandon,

Can you clarify your structure for us? You said you have "a layout that has thirteen other tables portal over information into the layout." What does this mean? Are you saying your layout has portals to thirteen different tables? If so, why?

[bwork]

ok, sorry. The layout in use is a form that inputs all the shipping discrepencies that occured. Each discrepency is listed in it's own table. Thus, on the main form all the little tables information is brought over by the use of portals. I didn't know of any other way to do it. I hope this helps explain it a little more. ie. one table not scanned, one table, not sent (etc..) they all come together on a log that lists all problems for the day.

Brandon

[Ender]

You should combine your different shipping discrepancies into one Shipping Discrepancy table, differenciating the different types of shipping discrepancies with a Type field. If you need to view a specific type of Shipping Discrepancy record, use an additional Table Occurence of the Shipping Discrepancy table, where the relationship has an additional criteria matching on the Type field.

With this structure, you would be able to easily create a discrepancy report with a list layout (based in a Shipping Discrepancy layout,) using sub-summary parts.

[bwork]

Thank you. I will get busy redesigning the database.

[bwork]

added question.

I am redoing the database, making one table that has all the discrepancies. There are 13 different discrepancies that can be chosen. Dependant on which one is chosen, there can be different variables. I believe I can accomplish this by making different layouts wtih the fields that I want. I don't know how to generate a summary report that would list all discrepancies for a certain date and then list the appropriate sub fields. The problem I see is that since it is all one table, I can't specify out which fields I want at a certain time. I hope someone can help with this and give me some insight.

Thanks In Advance