Portal Row calculation

[Johnny_one_eye]

Hello,

I am trying to create a calculation in which a field is filled in according to its portal row in a relationship. Each record in the relationship will only show up in the portal once. Is this possible?

J

[Johnny_one_eye]

Hello,

I am trying to create a calculation in which a field is filled in according to its portal row in a relationship. Each record in the relationship will only show up in the portal once. Is this possible?

J

[Johnny_one_eye]

Hello,

I am trying to create a calculation in which a field is filled in according to its portal row in a relationship. Each record in the relationship will only show up in the portal once. Is this possible?

J

[BobWeaver]

I'm not entirely clear on what you are trying to do, but if you have an unstored calculation field in a portal, you can use the Status(CurrentRecordNumber) function in it, which will return the current row number. Does that help?

[BobWeaver]

I'm not entirely clear on what you are trying to do, but if you have an unstored calculation field in a portal, you can use the Status(CurrentRecordNumber) function in it, which will return the current row number. Does that help?

[BobWeaver]

I'm not entirely clear on what you are trying to do, but if you have an unstored calculation field in a portal, you can use the Status(CurrentRecordNumber) function in it, which will return the current row number. Does that help?

[Johnny_one_eye]

Oh that worked well, even if you didn't know what I was talking about! However I do need something slightly different, so let me explain more thoroughly.

I have a database set up with employee jobs in it. These jobs change periodically but only one or two fields usually change (ex. Monthly Salary). To do this, we simply duplicate the entry and then change what needs to be changed. In order to prevent totally duplicate entries, I am trying to devise a method to order (and number) the jobs. Each employee may have more than 1 job listing, and each job listing may have more than 1 employee assigned to it.

So what I have done is created a self-join relationship that pulls up each job by EmployeeID and JobID and sorted them by the date the change occured. (So for example, if one of an employee's jobs has changed 4 times since he was hired, it would pull up those 4 records in order.) Now what I need to do is to create a field (OrderNumber) that will be automatically filled in. The easiest way I can think to do this is by using the Portal Row that the record comes up in. I can't just use a simple function to fill in the OrderNumber whenever a record is duplicated because sometimes changes are made long after the job is over and I need this to insert itself in the right position and obtain the correct number.

The method you gave me works because each row in the portal is numbered (ex 1,2,3,4), but I need this number to carry back to the original record. So if I display the portal for an EmployeeID and JobID and it pulls up 4 records, I need these original 4 records to display their respective row number.

Am I making any sense? If not let me know and I'll try to explain it better...

J

[Johnny_one_eye]

Oh that worked well, even if you didn't know what I was talking about! However I do need something slightly different, so let me explain more thoroughly.

I have a database set up with employee jobs in it. These jobs change periodically but only one or two fields usually change (ex. Monthly Salary). To do this, we simply duplicate the entry and then change what needs to be changed. In order to prevent totally duplicate entries, I am trying to devise a method to order (and number) the jobs. Each employee may have more than 1 job listing, and each job listing may have more than 1 employee assigned to it.

So what I have done is created a self-join relationship that pulls up each job by EmployeeID and JobID and sorted them by the date the change occured. (So for example, if one of an employee's jobs has changed 4 times since he was hired, it would pull up those 4 records in order.) Now what I need to do is to create a field (OrderNumber) that will be automatically filled in. The easiest way I can think to do this is by using the Portal Row that the record comes up in. I can't just use a simple function to fill in the OrderNumber whenever a record is duplicated because sometimes changes are made long after the job is over and I need this to insert itself in the right position and obtain the correct number.

The method you gave me works because each row in the portal is numbered (ex 1,2,3,4), but I need this number to carry back to the original record. So if I display the portal for an EmployeeID and JobID and it pulls up 4 records, I need these original 4 records to display their respective row number.

Am I making any sense? If not let me know and I'll try to explain it better...

J

[Johnny_one_eye]

Oh that worked well, even if you didn't know what I was talking about! However I do need something slightly different, so let me explain more thoroughly.

I have a database set up with employee jobs in it. These jobs change periodically but only one or two fields usually change (ex. Monthly Salary). To do this, we simply duplicate the entry and then change what needs to be changed. In order to prevent totally duplicate entries, I am trying to devise a method to order (and number) the jobs. Each employee may have more than 1 job listing, and each job listing may have more than 1 employee assigned to it.

So what I have done is created a self-join relationship that pulls up each job by EmployeeID and JobID and sorted them by the date the change occured. (So for example, if one of an employee's jobs has changed 4 times since he was hired, it would pull up those 4 records in order.) Now what I need to do is to create a field (OrderNumber) that will be automatically filled in. The easiest way I can think to do this is by using the Portal Row that the record comes up in. I can't just use a simple function to fill in the OrderNumber whenever a record is duplicated because sometimes changes are made long after the job is over and I need this to insert itself in the right position and obtain the correct number.

The method you gave me works because each row in the portal is numbered (ex 1,2,3,4), but I need this number to carry back to the original record. So if I display the portal for an EmployeeID and JobID and it pulls up 4 records, I need these original 4 records to display their respective row number.

Am I making any sense? If not let me know and I'll try to explain it better...

J