Hi Kathy. You can't link tables with container fields.
You have to link them based on a text field or a number field, date field, etc.
Let's say you have LargerImages table and SmallImages table.
LargerImages should have two main fields - A serial number which is your key, and the container field for the images.
The smallImages table should have two main fields, a number field and a container field for the smaller images.
Link the two tables using LargerImages' serial number field and smallImages number field.
Make sure you check the box that says allow creation of record via this relationship in the smallImages field if you want to add them via a portal.
Then, when you add records to the smallImages, just enter the LargeImage ID into the smallImage number field and they will appear via a portal, relationship, etc.
Hope this helps!
Thanks for the fast response. I did link the tables based on a number field. The trouble may be that I have multiple images for the same number. Should I add another number field so that I can give each large image a unique number? Should I put all the large images on one record with the number that I have now? Sorry to be so slow on the uptake. I only just started using Filemaker about 4 weeks ago and this is my first database.
When I started using filemaker about 7 years ago, there were no forums, no tech support, so I know what you're going through!!!
I would make each large image a different record, not add multiple number fields.
If you have to see multiple large images as well, then just make another table and link like this like this:
MAIN TABLE (PROJECT) serial_numberProject
LARGE IMAGES number_field_linkstoProjectID, serial_numberLarge
SMALL IMAGES number_field_linkstoLargeID, serial_numberSmall
OR JUST DO:
LARGE IMAGES ---- SMALL IMAGES
Each large image has a unique id to link small images to.
Hope that makes sense. feel free to ask for more help!
Here's what I have. A table named LP Recordings where each LP has a unique accession number (ex. 2008.1.735). I want to relate a table named Recordings Images which has images of the front/back covers and record label Sides A & B. I have the tables connected Accession Number to Accession Number.
Recordings Images has the fields:
Image Name (ie. Front Cover, Label 1, etc.)
Image (the container field with the picture)
I want a portal in LP Recordings that the user can scroll down through the images, then click a button for the image he wants to see enlarged.
I managed to set up a portal for the individual tracks on the LP that works fine. I linked that table with the Matrix Number. I don't want to use thisnumber because many LPs were issued with different cover art, but the same Matrix Number.
I am not sure what I am doing wrong. If there is a way I can attach a picture of my relationship graph let me know and I will do so.
that would help. send me an image.
Contact me via private message (top of this screen - right side - X Messages) to make arrangements.
I sent you a file. Hopefully you got it.
I have sent you a private message (top of this screen - right side - just below the blue bar - X Messages).