i'm working with a couple databases.

(1) list of songs with unique ids

(2) cd clips--which contain a custom list of clips of songs. (hence, the song length is always varied.)

on database 2, i have repeating fields for SONG ID entries, and SONG DURATION entries.

what i want to do, but need help with:

i want to see a song in database 1 and see how many CD's the song has appeared on. AND see the overall duration total. (e.g. if it has appeared on CD#1 for 10 seconds, and then CD#3 for 20 seconds, the overall duration total for that song should be 30 seconds.)

how can i do this?

thank you!!!!

Edited March 8, 200718 yr by Guest

Hi Chika,

Do yourself a favor and ditch the repeating fields and move to a relational model. Each repeat should have its own record. It will save you lots of time later on in development.