sorting a merge field

[toy]

hey im sure theres a simple answer

but i cant seem to figure it out

i have a relationship from one table to another

project->role via projectID

rolename is a field in role

there can be many roles for a project

currently

im trying to print out only the most current role added to the db

and im using a merge field to do it

so now my layout looks like this

"current project role is <>"

heres the problem

its still printing the first role i ever added to the project

so where i would like to see:

"current project role is role9"

im seeing

"current project role is role1"

ive set up the relationship with a descend sort by role::creationdate

can anyone give me insight to this?

thanks

TOY

Edited November 30, 2005 by Guest

[Raybaudi]

Hi

what about change your merge field with this:

<><>"

where rolenumber is sure a field you just have maded ?

[toy]

im sorry i dont get what youre trying to tell me

could you pls rephrase that?

thanks

[Vaughan]

Relationships pick up the first item that it finds, this isusually the oldest entry. You could change thos by specifying a relationship sort order to be (say) created date descending.

Alternatively create a calculation field that uses the Last() function. It will return the last related value.

[toy]

hey thanks

im a moron - i knew it was something stupid

i had the relationship setup wrong (wrong keys) - duh!!