Hi

is there an easy way to get to a record base on the record number
( not the one in the find, sort criteria)
Other than going into find mode, paste and find....

I'm using that free plugin that make great dialog with columns to
display releated or not records, upon selection I catch the record
Unique FM ID, go to the layout and go to that record.

The go to record number is only good when a number is set from the
found set but when going to another layout, the found set is not the
same.

Can we have a "go to record number" 2345 based on the FM Unique
number ??

did I miss some new feature in FM10 that allow me to do ? or did I
miss that longtime ago ??? :O)

Thank you

JF

On 2009-10-11 08:28:43 -0700, Bizouman <bizouman (AT) gmail (DOT) com> said:

You missed it long long ago. You can use Get(RecordID) to get the
unique internal FM id and then use that to find the same record in the
new found set. But you won't be able to go to a certain record in the
order, unless you use a looping script. FM doesn't know what record
NUMBER a certain record ID is.

But you can capture the record ID in a variable, go to the new found
set, and then (pseudocode)

Loop
Exit loop if Get(RecordID) = $variable
Go to Next Record (exit after last)
End Loop

This will be much slower, of course, if your found set is very large
and the target record is far down the list.

Or you can insert the record ID into a global field and Go To Related
Record in the other found set. This requires the creation of a new
relationship just for this purpose. You decide which kind of overhead
is most appropriate for your purposes.
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

thank, but I know the get (record id) :O) but this is can't be use to
go directly to a record.

let me explain how my solution is set up.
I have a main window and when going in search I create a new window
with a different layout and go in find mode.
if no result, loop for another search or exit.


if result = 1 , I need to close that window and return to the main
window and bring that specific record (and it's not working with the
get record ID looping, more than 10k record)

if result > 1 I switch to a new layout with a list view with all the
found records with a button to select the curent record and need to do
the same as above.

So, the go to related record is not working because both layout use
the same Table, and I have already so many tables, and duplicate
tables

So now i'm doing a set variable to my unique customer id, close the
window, return to main window, enter find mode, paste the value and
perform the find once again....

It's working.... but make lots of repeating find... any othe ideas ??

Thank you

On Oct 12, 7:16*pm, Bizouman <bizou... (AT) gmail (DOT) com> wrote:

That doesn't sound like a terrible method.

But have you tried just Go To Layout[]? Going to a different layout
based on the same table occurrence will maintain the same found set.
If you need to "switch windows", instead close that background window
and use the "find" window.

G

On 2009-10-12 18:16:45 -0700, Bizouman <bizouman (AT) gmail (DOT) com> said:

When you need to discover if there are related records in the SAME
table you can use a self-relationship.

TableA can be related to another Table occurance of itself, using the
relevant field. It can be a global (populated by script when the user
selects a record to start the location from) on the left(parent) side,
and the Key field on the right.

Then you can detect, using IsEmpty(Relationship::KeyField) whether or
not there are related records, and if so, Count() to determine how many
there are. Then you can branch to the proper layout, list or detail,
using GoToRelatedRecord.

The solution to a complex relationship graph is a proper naming
convention and adherence to a logical organizational arrangements. Many
developers like Anchor-Buoy, but there are other schemes just as valid
and a lot simpler.

Ray Cologon is a FM genius, and he's written a White Paper on graph
modeling that may help.
http://www.nightwing.com.au/FileMaker/resources.html
the title is 9 Steps Toward Enlightenment with FileMaker Pro.


Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

GRIP: yes now with the new option to allow entry into find mode only
can be use versus the FM6, when you don't give acces to field to entry
but use them in search... but I like the pop window so I can decide
what field can be use for searching and not having user enter search
criteria in none indexed field and create index for nothing...

LYNN: When I will have hours to spen I will read that white paper, but
the thing is I'm merging SQL data with FM10 data, so there's some
thing taht I can and some I can't do....

SQL can be way more powerfull... UPDATE xxxx SET zz=1 WHERE yy = 123
and you can udate many user that way in 1/10 of a sec.... FM don't
have that power...

And I'm tire of creating double of my table just so I can move from
layout to laout, or get information righ...

PS: I'm a HVAC contractor, my business is to sell and install AC and
Heating unit, not pass a hole year on a PC !! LOL so I'm re-doing my
old FM6 into FM10 and it's a wonderfull upgrade, but I have my
limition :O)

Have a nice day.

JF

On 2009-10-13 13:55:10 -0700, Bizouman <bizouman (AT) gmail (DOT) com> said:

Just had a local HVAC guy come in and estimate replacing our furnace
before heating season kicks in.

Perhaps you haven't yet seen this, but in FM10 (9 too) you can directly
place Table Occurances for SQL tables right in the FM relationship
graph. Then you can work with those records directly, including
updating them. You can use shadow fields to manipulate the data from
the SQL tables or move data in & out of each platform.

Have fun. FM10 is a great tool.
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer