Value list based on previous portal row

[Ben Ball]

Hi,

 

I have a portal showing various records. 1 to 10 say

 

portal row number  fieldA   fieldb

 

I need do have a drop down value list which only shows 1 value and that should be from the portal row above.

 

Ie

1. fieldAContent  FieldBContent

 

2. fieldA              FieldB

 

when i click in fieldA in portal row 2 I need this to show what is in fieldA from portal row1

 

can this be done if so how?

 

I tried various thing using the relationship model but obviously I can't use calc fields to form relationships. Or at least I think I can't

 

I guess I could use a script that goes to the previous row and grabs the field etc etc.. this may be the way?!

 

but ideally a value list..

[jbante]

If your fieldA needs to contain the same value for all of your portal records, you may have a data normalization problem: fieldA may properly belong in the table your layout is based on rather than the table your portal is based on. What are the tables and fields in question representing?