Portals summary and validation

[Zookeyper]

Hello world,

I'm building a dvd/cd database and so far it works pretty well. I keep running into trouble when trying to get data (numerical) from the portal I've used.

My portal contains disk: content, content type (movie, music etc.) and content size.

I used a calculation to "sum" the content size to create a "disk size" field. That works really well, but I also wanted to sum up the size of all the disks. I used a summary field but that doesn't work straight away. I have to re-open the DB for it to re-sum all the disk sizes. Maybe theres a better way to do this??

I'm also trying to restrict data entry within the portal. I used a validation on the content size field to try and make sure that "if" the disk type field was "DVD" it would only allow 4700 (MB) in the portal and otherwise ("CD") it would only allow 700 (MB). This too is a great function, but it only works on the first row of the portal.

Can someone help me??

Many thanks,

Zookey

[Reed]

If you can post the file, then it would be easier to see exactly how your relationships are set up, and why certain things aren't working.

Dana

[Zookeyper]

Sure,

Here's the file

thanks,

Zookey

Disk_Data.zip

[Reed]

Your attachment doesn't seem to be there. Maybe something with the new forum design....

Can we not add attachments anymore??

Edited July 16, 2005 by Guest

[Zookeyper]

Hi,

Resetting the cookies worked...It looks different but it does the same.... :

So I uploaded the file again. Maybe it'll work this time....

cheers!

Zookey

Disk_Data.zip

[Reed]

The summary fields don't refresh very well esp. when used on unstored calc fields. Easier ways to make them refresh are to switch to another layout and switch back, or change the found set. Summary fields depend on the found set, so changing that will force it to reevaluate.

If you always want the field to calculate everthing and not depend on the found set, then you could use another calculation field which would sum up all the sizes. I've attached a modified version of your file with this field below the summary field you created.

Your validation only works on one field because you're not validating on the sum of all related records. I changed your validation. I added a couple of table occurrences to your graph to make these changes.

Dana

Disk_Data.fp7.zip