Record Lookup|two fields, repetitions

[matthew wengerd]

Hello.

I am creating/managing a database which includes a table for audio (AUDIO) recordings and one for musical scores (SCORES:Jazz Big Band scores). My score IDs are assigned in two fields (one is alphabetic based on composer's name and the other is serial based on acquisition dated i.e. ELLD 001) and are a match in both tables.

In AUDIO, I have a field called "Track Names", which can hold up to 20 repetitions. I also have "Score ID pre" and "Score ID suff" which both have 20 repetitions.

I want to create a button at the end of each of the 20 repetition rows in AUDIO which will open a new window with the SCORE record associated with an album track.

I'm not sure if the repetitions will allow me to do this nor am I remotely familiar with scripting. Thank you in advance for your help.

I've stripped down our DB to give you an example, but I'm not sure how to post a .fp7 file.

[Inky Phil]

Hi Matthew

If you can .zip your file you will find a section in the full reply screen for attachments

HTH

Phil

[matthew wengerd]

sometimes it's easy to miss the obvious! :)

Jazz_Music.fp7.zip

[Søren Dyhr]

I'm not sure if the repetitions will allow me to do this

If you havn't developed regularly in filemaker since the early '90 should you SHY away from utilizing repeaters for what seems to be a many2many relation kind of type.

Repeaters are bad substitute for a normalized structure, where you usually end up recognizing that you have your boots filled with workarounds to keep you occupied from now to forever.

--sd

[matthew wengerd]

can you define a "many to many" relationship?

[Søren Dyhr]

Most invoicing systems falls or ought to fall into this category, since each itemline in the invoice is a jointable connecting the items table with the invoice.

But think instead of books and authors, one author could have written several books ...but one book can also be written by several authors. This metaphor seems very close to what it seems to be you wish to achieve... Bix Beiderbech played the cornet on which recordings??

--sd