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, 200520 yr by Guest

Hi

what about change your merge field with this:

<><>"

where rolenumber is sure a field you just have maded ?

im sorry i dont get what youre trying to tell me

could you pls rephrase that?

thanks

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.

hey thanks

im a moron - i knew it was something stupid

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