Dialog + find button

[js22]

Hi,

There is probabily a very simple solution to my problem but being new to filemaker I can't figure it out.

I'm building a database where the records are numbered. I need help scripting a button that when clicked brings up a dialog box that says "Enter record number to view". The user then enters the number and then displays that exact record.

If any one has any ideas that would help me out a lot.

Thanks,

js22

[LaRetta]

Hi js22,

What do you mean that the records are numbered? Usually, there are three mechanisms for numbering: 1) auto-enter serial numbers, 2) FileMaker RecordID and 3) FileMaker Record Number.

If you are viewing a found set (or even the entire set), and you script a button with:

Go To Record/Request/Page [ by calculation ] , don't put anything within the calc box, and leave unchecked 'Perform without Dialog' then the User activating that script will bring up the Record Number dialog. If there are 500 records, the User can type 250 and will be jumped to record number 250.

If that isn't what you need, you'll need to provide further information about your numbering scheme.

LaRetta

[js22]

Thanks for the reply,

I'm designing a database for the genetics lab that I work in. The numbering scheme is an inhouse way of record identification. So the record number could be PCR2 or PUR7, but it is unique.

So I have a button that says "Find PCR Record"

The dialog would be something like "Enter PCR ID Code"

and then it would go to the layout of PCR records and find the record with the unique identifier that the end use entered.

Hopefully this makes more sense.

Thanks again

[aldipalo]

It sounds like your user is looking at a "List View" of records and you want them to go to the record detail layout. If this is correct then all you need is a button set to GTRR (Go to related record). Click specify then check "Show only related records" and check "Show current record."

The button should be on the same line as the other data in the list view.

If that's not correct then LaRetta's advice is the way to go.

[LaRetta]

Actually, if it's list view then simple Go To Layout [ detail layout ] button on the row would work as well; GTRR not required. But if the need is to capture User input to make the jump then I suspect the requested record is not visible (and possibly not even the CPR field itself). GTRR would work also but it would require that the cursor be on the record you want (and so would Go To Layout[]) or using script parameter ...

I should think a find might fit the bill (per attached). It starts with list view but it is NOT necessary here; the field need not be present on the layout. And no additional global required to hold the find criteria either; Custom Dialog can handle it. But why not just let a User type the find criteria directly in the CPR Code field itself? I assume because that field isn't being displayed.

LaRetta

PCR.zip

Edited October 21, 2006 by Guest
Corrected script (added Enter Browse Mode)

[aldipalo]

Hi LaRetta:

I stand corrected. You need to do the GTRR thru a script. I use this on many of my list views, as well as portals, so I can quickly jump to the detail record. My button graphic is usually a right pointing arrow but just to make it easy... (see attached file)

Are you saying there could be a potential problem with this method?

Al

PCR.zip

[LaRetta]

Script has nothing to do with it, I'm afraid. The principle is the same whether script or Specify Button. My point was that GTRR isn't necessary (in this case). Take your Go button (in your example file) and attach Specify Button with Go To Layout [ detail ]. It works the same, no? It is because you are ON the record you want; all you need to do is change layouts. If you want a new window, it will work the same using script as:

New Window [ Name: Detail ]

Go To Layout [ detail ]

The current record is maintained regardless, which is why I suspected that the record or field isn't available to jump FROM. I should not have included a list view in my example. If you create a new layout without ANY fields, the Custom Dialog still works.

Portals need GTRR, yes, but list views don't because they are the same table occurrence.

LaRetta

[aldipalo]

That's why I love this forum. I always learn something new. :

[js22]

Thanks for the help.

The example you attached was exactly what I was looking for.

js22