Hi there,
I am a relative newbie to Tap Forms Pro. I am still setting up my database, and my only previous experience in relational databases was a very early version of Filemaker Pro probably about 20 years ago!
So… my question relates to linking forms / databases. I have a form which is for building a catalogue of individual songs including stats / lyrics etc. My second form is for building a catalogue of albums. What I want to do is to be able to assign individual songs to show the album(s) on which the songs may appear on (including the song order on the album).
I have experimented with the “Link To Form” field, but I just can’t figure out how it actually works in terms of setting it all up, as well as how I actually assign / link from the individual records.
Any help / suggestions on what I need to do to set up, and how it all works practically when I am in individual records?
Thanks so much!
Kind regards,
Matt
I believe you want a many-to-many relationship. An album can contain many songs and a song can belong to many albums. Try looking at the Relationships section of the online manual, which you can access from the Help menu of the app. I am not an expert on relationships in TFP but that’s where I’d start.
As an aside, you may need to consider not using the song title in the relationship because there may be different versions of the same song, unless you add another identifier to the name (live, demo, take 1, take 2). Just a thought.
I’m sure someone here will be of more help to you. Good luck.
Thanks for that. All the songs will have a unique ID number as well as the song title, which I think would solve the issue of just using a song title in the relationship.
I am reading up on the manual, but I’m more of a practical learner, so I guess I might just have to muddle through and work out how it all comes together by trying to understand what the manual is saying along with a bit of trial and error…?
Here is an example of a simple many-to-many relationship.
Attachments:
You must be
logged in to view attached files.
FYI, with many-to-many relationships, you simply select a child record from the parent record to link the records together. So it doesn’t matter what the uniqueness is of the song titles.
If you use a Join Link Type, which essentially is also many-to-many, then you have to have a field in your parent form that matches the field in the child form. So a good match would be the artist name.
.
