 |
|
| Computers Forum Index » Computer - Databases - Filemaker » Go to Record... |
|
Page 1 of 1 |
|
| Author |
Message |
| Bizouman... |
 Posted: Sun Oct 11, 2009 3:28 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Martin Trautmann... |
| Posted: Sun Oct 11, 2009 5:16 pm |
|
|
|
Guest
|
On Sun, 11 Oct 2009 08:28:43 -0700 (PDT), Bizouman wrote:
Quote: 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....
goto related record.
Quote: 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)
There's the goto record command itself where you may use a calculation
for that purpose.
- Martin |
|
|
| Back to top |
|
|
|
| Lynn Allen... |
| Posted: Sun Oct 11, 2009 9:31 pm |
|
|
|
Guest
|
On 2009-10-11 08:28:43 -0700, Bizouman <bizouman at (no spam) gmail.com> said:
Quote: 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)
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 |
|
|
| Back to top |
|
|
|
| Bizouman... |
| Posted: Tue Oct 13, 2009 1:16 am |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Grip... |
| Posted: Tue Oct 13, 2009 1:39 am |
|
|
|
Guest
|
On Oct 12, 7:16 pm, Bizouman <bizou... at (no spam) gmail.com> wrote:
Quote:
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 ??
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 |
|
|
| Back to top |
|
|
|
| Lynn Allen... |
| Posted: Tue Oct 13, 2009 5:15 am |
|
|
|
Guest
|
On 2009-10-12 18:16:45 -0700, Bizouman <bizouman at (no spam) gmail.com> said:
Quote: 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
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 |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Sat Dec 05, 2009 7:40 pm
|
|