Setting Index To Go To Matching Record

[stealth162]

I setup an index field which get's the values from a field of each records field that I've called "Title". This lets me see the titles of all the records in a handy pull-down menu. What I'd like to do is add some sort of script so that when I select a title in this pull-down menu it takes me to that record.

Any thoughts?

[Raybaudi]

Hi

the easiest way is to make a relationship so, for example:

1) Make a new table ( named FIND ) with only one global ( or even simple ) text field ( named FIND )

2) Attach the Value List coming from field YourDB::Title to this global ( or even simple ) field

3) Looking the graph of the relationships, make:

YourDB::Title------------ = ------------FIND::FIND

3) while in Layout Mode duplicate your Layout and add the field FIND::FIND ( into upper side ? )

4) from Menu: Layouts >> Layout setup... >> Show records from: FIND

5) create a new record in the table: FIND

Now, whichever title you choose in the field FIND, you'll be able to see the original record.

[stealth162]

Thank you for your response, but I'm not sure I understand.

Why would I need to create another layout?

[Raybaudi]

Because you have to show the related record of your table FROM find table

[stealth162]

By doing this won't all my records now be contained within the "FIND" table as I create them? I have multiple layouts/views setup that view the same records and I am trying to implement this pulldown menu for only one of those layouts.

Sorry if I'm not following you. I'm trying to grasp it. Thanks for your help.

[Raybaudi]

The "FIND" table has only one record and only one field...and so it will stay forever.

But we need to make a layout for this table; the simplest way is duplicate an existing one, as I said on 3).

"I am trying to implement this pulldown menu for only one of those layouts."

OK, so try to duplicate that layout or change that layout so that it displays record of your table from FIND table

[stealth162]

Can I not just change the layout that I want to use the menu with and have it refer to this table?

[Raybaudi]

Yes, you can

[stealth162]

Cool, I'll give it an attempt tonite. Thanks.

[stealth162]

Ok, I lied. I just tried it and followed step by step (or so I think) and it doesn't seem to work.

Would you be willing to take a look if I send the db to you?

[Raybaudi]

Sure !

[stealth162]

Thanks, I sent it to your email you have on your profile.

For anyone following, I'll post what the problem was once he figures it out.

[Raybaudi]

It is OK now !

there was a wrong relationship...

You make: CueTitle = CueNumber !!

I'm sending back your file with right relationship.

[stealth162]

Only one small probelm I encountered with this method. I can no longer navigate to the next sequential record without using the pulldown menu. Previously I used the next and previous record command, but since this is performing a "find" there is only the one record.

Any thoughts on work arounds?

[stealth162]

2nd small problem. I can't create new records in this layout since it is only referring to the main table.

Any ideas?

[comment]

I think you only need one table, with a self-join relationship. Hard to say for sure without seeing what you're talking about. FYI, you can attach files directly to your forum's messages very easily.

[stealth162]

I set it up using only one table and that seems to work the same way. I'm not able to advance record by record within the database nor am I able to create new records.

I'm happy to email you the db if you're willing to take a look, however I am preparing the db as shareware (small fee) and don't want it to get out to anyone early. Let me know if you can take a look.

Thanks.

[comment]

There's no need to post anything sensitive. In fact, it's preferable to post only a small file demonstrating the problem. But I believe this forum is for everyone, either to contribute or to benefit from.

See if the attached helps.

JumpTo.fp7.zip

[stealth162]

I've looked over your example file and have tried to get it to work on my end to no avail. I've attached a sample file of what I've been trying to get to work. I'm trying to get the menu to respond to "cue number" and "cue titles" fields which are both user enterable fields.

Let me know if you can figure out what I'm doing wrong.

Thank you again for all the help so far.

GoToRecordHelp.fp7.zip

[Raybaudi]

Hi

a little mod of your file.

GoToRecordMod.zip

[stealth162]

O.k. I must be totally lost somewhere along the line.

What did you change? I can't figure it out.

[Raybaudi]

While in Layout mode, check the "go" button...

Get related record from: Quick Menu !

[stealth162]

Fantastic! Thank you.

Is there any way to have it automatically go to the record when you select it in the pulldown menu instead of having a "go" button?

[Raybaudi]

Yes...

Have you an Event plugin like EventScript ?

It is a free plugin like ZippScript or the FmButterDoScript... they all are a MUST !

[stealth162]

Never worked with a plug-in. No way to do it without a plug-in?

[Lee Smith]

A button next to the field that you attach the script to (often refered to as a Do it button).

Edited January 25, 2007 by Guest

[comment]

I can be sort of done without a plugin - but it works differently for Windows and Mac. And it will flash quite horribly on a Mac.

See here.

[Raybaudi]

I can't understand why not start to use plugins now... it is easy and reliable !

Or wait for FMP9 late this year to have Events nativelly !

www.thinksecret.com/news/0701filemaker9.html

[stealth162]

Thank you to everyone for all the input. I'll probably stick with the "GO" button next to the value list for now and hold tight for Filemaker 9 to come out. I want to stay away from plug-ins because this database is distributed among many users who do not have the knowledge or patience to do something as simple as installing a plug-in.

Thanks again for all of your help.