Color calcualtion woes

[jhomer]

Question for the gallery:

I have an inventory system in which i have a list of materials. These materials can be run through production but if all the m aterial is not fully produced we return that material to stock and capture the reason. The return to stock information is stored in another related table.

As so i have an interface from the inventory perspective looking into a return to stock portal.

my problem is with a calcualtion for the new weight. which is the origonal weight minus the used weight. I want to be able to designate the last available new weight a different color. i have tried to relate the rts info to itself to no avail and then also tried an if portal row = 1 solution but that only worked if the user was on the portal.

is there a way to highlite the last new weight without having to be int he portal??

as always all help and suggestions are welcome

[Robert Kidd]

I think it may help to post a file.

[jhomer]

I'd like to but am not able to due to publication restrictions. if any one needs additional clarification on this let me know and ill see if i can better explain

[Robert Kidd]

Where are the weight fields held ? In the inventory table or the return to stock table ? What do you mean by the last available weight ?.

Could you create a new file with just the tables fields you are talking about ?