Portals - sorting and go to current record 
Author Message
 Portals - sorting and go to current record

If you are using Filemaker 4.0, you can define the sort order for the
related records in the define relationships window.  If you sorted by date
in descending order the most recent record would be first in the portal.  
This feature (defining sort order for a relationship) is not available in
Filemaker 3.0.

________________________
N.Eric Olson
Department of Pathology
University of Washington
Seattle, WA 98195
(206) 616-5948

________________________

Quote:

> Hi again

> Now I have another hitch, Data base of patients who are being I have a
> portal showing 2 rows of data (a one to many relationship)

> Each time a new record is recreating in the related database it is
> date and time stamped. In the master database portal to these fields,
> I want to go to the comments field of the record just added. When I
> use the go to Portal Row Last it actually takes me to a blank record
> below the last(current) record.

> So I tried to sort the related dbase by date time having the latest
> record at the top, if I perform the sort manually at the related dbase
> the current record is first, BUT once I call this sort from a script
> in the master dbase the portal row as seen in the master is not
> sorted.

> HELP.....

> PS Can anyone explain why there is a blank row in the portal and why the go to last command takes the cursor there and not to the actual last record.
> BFN
> OOROO
> Michelle



Mon, 22 Jan 2001 03:00:00 GMT
 Portals - sorting and go to current record

Hi again

Now I have another hitch, Data base of patients who are being I have a
portal showing 2 rows of data (a one to many relationship)

Each time a new record is recreating in the related database it is
date and time stamped. In the master database portal to these fields,
I want to go to the comments field of the record just added. When I
use the go to Portal Row Last it actually takes me to a blank record
below the last(current) record.

So I tried to sort the related dbase by date time having the latest
record at the top, if I perform the sort manually at the related dbase
the current record is first, BUT once I call this sort from a script
in the master dbase the portal row as seen in the master is not
sorted.

HELP.....

PS Can anyone explain why there is a blank row in the portal and why the go to last command takes the cursor there and not to the actual last record.
BFN
OOROO
Michelle



Tue, 23 Jan 2001 03:00:00 GMT
 Portals - sorting and go to current record
On Thu, 6 Aug 1998 20:59:44 -0700, "N. Olson"

Thanks very much Eric

It works just fine ....

Quote:
>If you are using Filemaker 4.0, you can define the sort order for the
>related records in the define relationships window.  If you sorted by date
>in descending order the most recent record would be first in the portal.  
>This feature (defining sort order for a relationship) is not available in
>Filemaker 3.0.

>________________________
>N.Eric Olson
>Department of Pathology
>University of Washington
>Seattle, WA 98195
>(206) 616-5948

>________________________


>> Hi again

>> Now I have another hitch, Data base of patients who are being I have a
>> portal showing 2 rows of data (a one to many relationship)

>> Each time a new record is recreating in the related database it is
>> date and time stamped. In the master database portal to these fields,
>> I want to go to the comments field of the record just added. When I
>> use the go to Portal Row Last it actually takes me to a blank record
>> below the last(current) record.

>> So I tried to sort the related dbase by date time having the latest
>> record at the top, if I perform the sort manually at the related dbase
>> the current record is first, BUT once I call this sort from a script
>> in the master dbase the portal row as seen in the master is not
>> sorted.

>> HELP.....

>> PS Can anyone explain why there is a blank row in the portal and why the go to last command takes the cursor there and not to the actual last record.
>> BFN
>> OOROO
>> Michelle

BFN
OOROO
Michelle


Tue, 23 Jan 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. FILTER PORTAL RECORDS - DISABLE ADDING NEW RECORDS IN A PORTAL

2. Omitting current record from portal

3. going to related record scrolls my portal to the beginning

4. Error causes current record to go to editmode=0

5. sorting new record to top in portal

6. sorting portal records?

7. Displaying Portal Records in sorted order

8. Go to First Record and Go to Last Record

9. sort, but stay on current record?

10. Using ADO: current record remains NOT current after Update

11. Oracle Portal-to-Go

12. Portal-to-Go?


 
Powered by phpBB® Forum Software