Ultimate Database

{PREVNEXT(n1, n2, n3, n4, n5, n6, n7, n8)}

Displays a link to the previous or next item in a list.

'n1' is the parent object id of the list.

'n2' is the relationship type between the parent object and its children, which is usually 0. This can be a minus number if it is a parent relationship.

'n3' is the ID of the current object. This will usuall be "COID" which will insert the id of the current page.

'n4' is the direction. -1 = previous, 1 = next.

'n5' is the default order.

'1' is alphabetical,
'2' is most recent,
'3' is highest rated.
'>3' indicates the id of the relationship to the object that is to use for the order.

A minus sign in front of the order states that it is to be displayed  in decending order.

'n6' is the text to be displayed in the link. This will default to "Previous" or "Next"

'n7' is the id of the limiting relationship.

'n8' is the id of the limiting object via the relationship.