Highlight appears on last row of portal

[Chalkster]

I have been experimenting with highlighting portal rows according to certain conditions

Mostly it works well but I have one problem in portals where a user can create records in related tables.

For example I have a table Routings which holds the ID name and notes for an airfare routing. The routing is specified in a number of related tables. Vias, Segments, Direct flights, and Stopovers

What I am trying to do in these portals is to validate data as the user enters it. So that if he has entered data in a portal row but it is invalid then the field or row is highlighted acording to the error.

I set up a calculated check field to validate the data... if it returns a 1 then everything is ok. A 0 means the data is invalid, if data is invalid I want to highlight the that row or field. Behind the portal is another calculated field "highlight", the calc for this field is that if "check" =0 the result is a container that highlights the portal row with the error.

So far so good... everything works fine except for one problem.... the last empty portal row always shows the highlighted field before any data is entered . I set the check field to Case (IsEmpty(datafield);1; ... as the first part of the validation but it doesnt work the last portal row is still always highlighted before data is entered.

I guess it is similar to the problem of having a button on a portal row that always shows on the last empty row before data is entered...... that isnt a big issue to me but I would like to get rid of the highlight on the last row if possible since i only want to highlight a row if it is incorrect data

[quillpro]

Have you tried auto-entering 1 into the field?