ID button

[tripdragon]

I need help with an idea. I have a barcode feild that has an increment of 1 for each record. I then have this file with many relationships to a folder of files each with this unique barcode number.

How can I make the barcode number act as a button and open the corisponding file with the barcode number ?

[Fitch]

On a Mac you could use AppleScript. A very good cross-platform solution is Troi File plugin.

[jfmcel]

With FM 7 you can set a calculated container field to a calculated file path. If you can construct the file path in a calc, you should be able to open the file (or view the image if it is an image).

[The same calculated file path would be need for the aforementioned AppleScript.]

[bruceR]

tripdragon said:

I need help with an idea. I have a barcode feild that has an increment of 1 for each record. I then have this file with many relationships to a folder of files each with this unique barcode number.

How can I make the barcode number act as a button and open the corisponding file with the barcode number ?

Are these Filemaker files or some other file? Are you still trying to do that weird stuff where you have umpty nine Filemaker files instead of a real database?

[tripdragon]

BruceR said:

Are these Filemaker files or some other file? Are you still trying to do that weird stuff where you have umpty nine Filemaker files instead of a real database?

HE h heh. We tried that system, it lead to a quite messy huge file that was a b-

[Oldfogey]

Am I missing something? Is your barcode field actually a Container or is it a Text field using a special barcode font?

You can treat any field as a button to launch a script and extract the value of that, or any other field. What's the problem?

[tripdragon]

Oldfogey said:

Am I missing something? Is your barcode field actually a Container or is it a Text field using a special barcode font?

You can treat any field as a button to launch a script and extract the value of that, or any other field. What's the problem?

It is text, and I need it to be dynamic, as in not a button, or at least a very dynamic button

[bruceR]

"HE h heh. We tried that system, it lead to a quite messy huge file that was a b-

[tripdragon]

BruceR said:

"HE h heh. We tried that system, it lead to a quite messy huge file that was a b-

[tripdragon]

If I smush all of the files into FM7 will that let it draw from the tables ? Or do I have to compile it into another FM7 thinking method ?