Dear FileMaker Community,
I’m an absolute beginner with no knowledge at all regarding FileMaker. All the knowledge I have so far is thanks to the YouTube channel of Guy Stevens. I’m a big music fan and I was looking for a way to store the items I want to buy. I created a number of Tables and I’m completely stuck on how to join the necessary Tables into the final Table.
This is what I have done so far.
Artists: Id, Artist, Genre, Picture
Discography: Id, Artist, Title, Type, Release Date
Track Listing: Id, Artist, Title, Track_Number, Track_Title
Releases: Id, Artist, Title, Year, Label, Catalog, Notes
The Type field in the Discography Table is either an Album, Compilation, Single & EP or DVD/Video
The Label field in Releases is of course the Record Label
The Catalog field in Releases is actually the order number
The first problem I encountered is the container/Picture field. I can insert pictures but I want them the same size as the files I need to insert. Is there a way that they automatically take the original size? Another problem is the Track Listing. When is it only one CD for example than there is no big deal but for instance take a box containing like 15 CD’s how could I manage this?
The biggest problem for me is to get the necessary data from this Tables into the final Table called Wishlist. In attachment I placed an Excel file to show how I more or less see the final outcome of this Table. It would be nice that the output could be shown in three tabs (info, Track Listing, Releases).
Can someone please help me out? Please know that I would really appreciate this.
P.S. please note that the file in attachment is just a quick sketch.