jwparker

It does work, now, and as you point out, the UI is not the slickest. Are you referring to the method where you discussed popping a window via scripting and selecting from there? It makes sense, to a point, but wouldn't I have the same issue with multiple lines in a portal in a separate window? With a list layout, wouldn't you have to open that window a number of times = to the number of choices needed? The original db had checkboxes, but the number of choices outgrew that solution, and it was impossible to keep in sync with the images db. This works, for now, as it's only me using the db. As for validation, the combinations are often NOT unique -- one of my reasons for tracking this data is to find reocurrencs of the same combination. Are you saying that each submission record should be unique, or to validate the choices as unique? Not sure I understood the reason for unique validation. You've been a great help -- glad I stumbled in here.

That sounds right on! If I can figure out how to get the record to commit (a deep problem affecting many people in today's world ;-) I may be there. I do appreciate your assistance. I'll give this the old college try tomorrow and see what other problems crop up. Thanks again. jim

Your help got me into the ballpark -- I really appreciate it. I was able to reference the secondary file, but I'm getting some flaky behavior with the simple script that pops the ImageID in the Show_Yr layout. Clicking on the button in the portal only results in a blank edit field -- I can type an ImageID code and tab out of the field, and then it will populate correctly, but it won't do it on it's own. I have the join table set to allow record creation, but I'm not sure that the button is triggering it properly. The other odd behavior is that once I get the drop down menu to populate correctly, it will still add multiple instances of the same image to the submitted images layout as individual records, which it shouldn't do, according to the example. I've attached the second revision of the files -- I hate to be such a stupido! But getting this small part working has cost me the better part of two days and I'm still nowhere near done! Oh well! Thanks again -- ShowsImages_2.zip

Ok, thanks. Wasn't sure if the syntax needed to change. I did put a TO into the relationship diagram and linked to it, but that file did not function properly. Somewhere, something is kerspuggled. At least syntax is not at fault, thanks.

What would be the syntax to use a file reference instead of an internal table in the calculated field: // FOR VERSION 8.5: List ( Affiliations::OrganizationID ) & "¶ " // FOR PREVIOUS VERSIONS: // ValueListItems ( Get (FileName) ; "MyOrganizationsIDs" ) & ¶ Just changing the names and labels in the three tables in the example to conform to my data works, but I can't seem to make the example work with an external file reference to the image list. It's important to me to keep the image database separate as that will form the basis for a much larger inventory database. the images should be consistent in both databases, as I'd like to be able to edit that list once, not twice for every addition or change.

I'm not sure that this is what I'm looking for. A show can have multiple images assigned to it; an image can be used for more than one show. I'm going to have to look at the dwindling list example more closely to see -- thanks! One question -- the dwlist example uses three tables in one database -- can a linked database be used in the same fashion as the organization table? And I don't understand the relationship between the cMyOrganizationIDs calc field and the unaffiliated organization table occurence yet. What's the function of that -- not to be stupid, but that looks like the crux of the matter. Thanks for your help -- this might be the answer, I just don't get it yet.

I want to use a list of images from one database as a value list in another database. The list in the first db needs to be able to display more than a single image, so I have the two linked via a join table, and use a portal to display the image list. My problem is that I don't want to add records to the image list each time I use one of the values in the portal. I can't figure out how to JUST use the values, and not create a new record each time I choose one of the images. Using the image database as a simple value list in a repeating table doesn't work, as choosing one value populates the other values with the same name as many times as it is chosen. More detail on the database setup: The first database is a list of shows. Each show needs to display and store data on which images were sent for judging. The image list changes over time, and is also the basis for my inventory, so one instance of each image is all that should be in the image list. I've set up the show database to auto-create a primary key each time a new year is added. The image database also creates a key for each image as images are added to the database. These two keys are used to link the two databases in a join table. The relationship coming from the show side allows creation of new records in the join table; the join between the image list and the join table allows creation of new records in the image list. My problem is that they won't link if I turn OFF the create new record in the image list, but I don't want to create a new record in the image list, just use the names. Is there a better approach to this? The image list works really well as a drop down to auto fill. Each show needs to be able to add a variable number of images that were sent for judging in the portal field. The attached sample file shows how the first show record has added three duplicate image records to the image db -- any suggestions appreciated here. I know I'm doing something wrong, but can't figure it out. TIA Jim ShowsImages.zip