I need some help creating a script, if you all would be so kind.

I have two tables. One called "Library" that has unique records each with it's own library number. The other table, "Music Videos" has records with duplicate library numbers.

I have a layout using Library with a portal to Music Videos based on Library number.

I need to merge the fields in each Music Video record into a field in Library based on Library Number. Music Videos has multiple records with the same library number. Basically I need to get rid of the Music Video table so searching is easier for users.

I'm not that fluent with scripts, so any and all guidance is welcome.

FileMaker Version: 7

Platform: Mac OS X Panther

I'm not too clear on exactly what you are trying to find but I suspect your design is the 'wrong' way round.

If you are trying to find a Music Video in a particular Library, your current layout shuld be fine.

If you are trying to find which Library has a particular Music Video, you need a reverse relationship with a portal in the Music Videos file listing the Libraries.