Calculation Help-Track times...

[unicronxxx]

Hello all,

I am looking forward to being a part of the community here. Looks like there is a ton of information to learn from. I have a question, that i cant seem to find the answer for, and the search button didn't really help, so here it is:

I need to create a database that can easily calculate time figures. I can find a ton of stuff for calculating in-out times, etc. but i specifically need to add figures of time. Here is an example: I need to add up track time on a CD. So i would like to have one field that can have up to 99 times (the max tracks a CD can hold) and then have a separate field that will display the total amount of time that those tracks add up to. so if i enter 3 - :30second times in the time fields, my "total field" should read 1:30. Is that possible??? I have done much searching on the forum here as well as googling it. no real result. But maybe i am not searching for the right thing. It sounds like it should be easy, I just cant figure it out. Any help would be great. Thanks!

[Colin Keefe]

You'll want to build a relationship between two table occurrences - CD and Track - using CD_ID as a match key.

CD

----

__kp_CD_ID

CDName

Track

----

_kf_CD_ID

__kp_TrackID

TrackName

TrackTime

Then you can place a calc field in the CD table along the lines of:

Sum(Track::TrackTime)

If you're not sure what I mean by relationship or match key, I'd suggest reading through the Relationships section of this forum...I'd also suggest picking up a how to FileMaker book - they really do help!