I'm trying to introduce a system of highlighting in to a portal... basically when a user chooses one of the records, they hit a hidden button that sets a field in the current table to a particular id from the related table... thereby basically "selecting a record"...

the highlighting field, in the related table is just If(Count(related::field) = 1 ; Highlight ; "")

... now it all works fine and so it should... unfortunatley this is a multi-user solution and the the field in the current table has to be global... when the field is global though the calculation seems to always evaluate to true, therefore always highlighting... ive played with this before and never found a solution, any ideas anyone?

Any help or correction of thought direction would be really appreciated

genx

When User clicks row, set the related::ID into gID global text. In your related table, create a calculation (container) unstored with:

If ( ID = MainFile::gID; Highlight; "" )

... where Highlight is your container field holding the color swatch. Place this calculation on your row, turn off entry in Browse or Find and Arrange > Send to Back.

UPDATE: Your method was close, but it would eval as true if even ONE related record EXISTED. By using a global AND tunneling the result to ONE record back in your main table (the one selected in the row), you highlight is isolated. And, since each User uses the global and enters different IDs, there will be no conflicts to deal with.

Edited February 13, 200619 yr by Guest
Added Update

thanks lots :