Creating and maintaining sequences

This topic contains 1 reply, has 2 voices, and was last updated by  Brendan 2 months, 1 week ago.

  • Author
    Posts
  • March 12, 2019 at 3:28 PM #33990

    Ladd Vagen
    Participant

    I’ve collected many album recordings on reel-to-reel tapes, mostly my own recordings. I’ve kept track of the songs and the artist in the sequence they were recorded on the reel – this all on paper back in the 1980s. Now, I want to be able to create a catalog database of the reels and the songs on them, including the artist, in the order in which they were recorded. I sometimes have the same song on multiple tapes for various moods.
    I’ve created an artist table and a songs table – one (artist) to many (songs) – works great.
    I’ve created a reel table with the idea to link the songs (one (reel) to many (songs)) in the order in which they were recorded, pulling in the artist as well. I add them to the reel table in that order, but they don’t maintain the sequence – they default to sorting by name, which isn’t what I need. I can’t put a sequence number in the songs table as the song may appear in different places on different tapes.
    Any suggestions, ideas, or brilliant alternatives? Let me know if any further explanation is needed. The reel, artist, and song table are pretty simple.
    Thanks, all…

    March 12, 2019 at 8:52 PM #33991

    Brendan
    Keymaster

    Hi Ladd,

    This is where Table fields come in handy. A Table field is much like a Link to Form field in how it is displayed, but there’s no direct relationship between the Table field and another form. You do link it to another form though, but the idea is that when you select records from the linked form, Tap Forms will copy the values from the selected records into the Table field. It copies the values from any fields that have matching names.

    With this ability, you can have a Songs table that mirrors a Songs form that contains the master list of songs, then add an extra field to the Songs table that is the track number. That way you can have the same song in different albums that have different track numbers.

    The only downside of this approach is because Tap Forms copies the values from the selected records and doesn’t directly establish a relationship between the records, you wouldn’t be able to go to the Songs form and see a list of albums a song is contained on like you could do with a real relationship.

    Hope that makes sense.

    Thanks!

    Brendan

You must be logged in to reply to this topic.