unless I'm mising something painfully obvious, there are a couple of very
A. order form
B. Image list
create a global constant field in A, g_a, add the field to the layout, and in
browse mode enter a
create a text field in B, constant_a, and set it to auto enter a (this will
fill new records), find all records and use replace to fill all records with a
create a relationship in A, rel.1 g_a::constant_a, to B
add a portal to your layout in A using the rel, and add appropriate fileds
Result: scrollable list of image names.
Add a button to the first portal row in layout mode, this will then appear on
all portal rows in browse mode.
Attatch a script (in Scriptmaker in A) to the button, that sets the 'image
name" field in A, to the image name of the portal row item
set field A.imagename to rel.1::imagename (add a go to layout, original
layout/refresh step) i.e. 2 line script.
there ya go, scroll the list, click the button.
create the image name field, create a value list, and attach to the field as a
this is a bit unwieldy if there is a large list of names in B
variation on method 1
if the dbB has the images as well, or if it can be linked to the images, you
can scroll the actual images in the A portal
> I'm sure this is a completelly obvious question:
> I've got two databases, the first one is an order form and the second is a
> list of images that can be displayed on the order form.
> To set the order form image I want to have the image list brought up, so it
> can be searched previewed, etc - then click a button and the image ID is
> stored in the orderform as a reference.
> I had the idea of using scripting to open the image-browse database layout
> then pausing the script. Then there's a button next to each image that would
> resume the script - then the script would use Set Field to pull the image ID
> into the order form... but the Set Field doesn't work! I'm pretty new to
> Filemaker so sorry if it's a real basic question.
> Thanks in advance