Multiple occurances of the same field in a record

[lance667]

Okay...here is... I have a database called CDROMS. Each record represents one CDROM. There are 8 fields in each record that represent the individual songs in each CDROM. The titles are something like jazzsong, bluessong, happysong, sadsong etc. The problem is that the user that created this data base did not assign separate fields to each song (ie. song1, song2 song3) but instead assigned a relational field to another database. So all eight titles of the song are contained in 8 fields called :title. How do I do a FIND based on each title to the other database if I cannot distinguish the fields in the record? Is there an internal array or dataname that can be referenced when you have multiple fields that are the same field? (My client cut and pasted the same field 8 times and assigned the relational field that way)

Any suggestions?

[lance667]

Let me clarify..Im creating a webpage and need the CDML to read a record in the CDROM database, look up the 8 song titles and do finds of each title in a database called SONGS. Thanks