Music Transposition Table problem

[antknee]

Hi All,

I've just joined as my database use has went up somewhat.

I am writing a database for a music project and I'm having problems with calculations on texts.

I have one field chord 'chord in c tonic' which will contain a chord in text description (with music symbols from ASCII char set) like Cm(add 9)/E♭

I want to transpose this chord in C tonic and present it in different tonics i.e. the same chord in D, E, F tonic (aka musical transposition).

So the chord

Cmin(add 9)/E♭ would be

D♭min(add 9)/E in D♭ tonic

...and so on for all the other notes of the chromatic scale.

I thought the best way to achieve this would be have two calculation functions with the second being a big if-then swap i.e.

1. dynamically copy 'chord in c tonic' to 'chord in D♭ tonic' if field added or modified

2a. in 'chord in D♭tonic' search for C, replace C with D♭

2b. search for C♯, replace C♯ with D

2c. search for D♭, replace with D

2c and so on.

3. end

but i just can't form the calculation and the right approach to recursing - it is a little confusing. I only ever want to maintain details manually for the 'chord in C tonic' - not all the transpositions.

Any help appreciated. I'm using Filemaker 10 on OSX.

Best Regards

Anthony

[antknee]

sorry for no example...

within the calculation I have Substitute ( Chord C Tonic; ["C" ; "D♭"] ;["D♭" ; "D"] ;["D" ; "E♭"] ;["E♭" ; "E"] ;["E" ; "F"] ;["F" ; "F♯"] ;["F♯" ; "G"] ;["G" ; "A♭"] ;["A♭" ; "A"] ;["A" ; "B♭"] ;["B♭" ; "C"] )

repetitions = 1

but is isn't working - looks like it's doing all rules at once...rather than the first match then exit

thanks

[comment]

I did this some time ago.

TransposeChords.zip

[antknee]

Hi Commet,

Thank you so much! I'll study this.

Anthony