multiple values 1 field

[Himitsu]

I have seen this somewhere just can't remember for the life of me where I saw it. I want to have a field that is caculated as:

if(

aTable:ID notequal bTable:storeIDs; textStyle(aTable:comment, BOLD);

aTable:comment

)

What I want it to do is if someone has read a comment, then they click a button that runs a script to set the ID number into a field so that comments, through a portal, won't be bold. So the bold ones haven't been read yet, like a new message system. These are messages that everyone sees on their own bTable. aTable is open to everyone to write to. I was thinking that one field that had the aTable:ID values in it seperated by the return command. But that only works with text. Any ideas?

[Fitch]

I think your return-separated IDs idea is probably the way to do it. A text field can relate to a number field in FileMaker, so it will work.

The only other option I see is to have another table with the comment ID and user ID. Maybe to keep that table from growing huge you could create a record for every user for each new comment, and then delete the record once the comment's read.

[Søren Dyhr]

I think I would work it further from this approach - Look at the attachment!

The way it works is, toggling bold on and off by clicking, and entering the field value by using a modifyer key when clicking.

--sd

BoldUnbold.zip

[Himitsu]

Soren,that is good, but in my setup, what you call the mail table, isn't related only to one user. It is a message board for everyone. So, the relationship is related to a feild I call boolean that auto enters a 1. I used to use the "x" relationship but that won't allow making new records through that type of key. So I need it to remember which one a user has clicked on. Kind of the opposite direction. I will try to flip it around and approach it from the main to the mail table, but how it is setup now, is from the mail table to the main table to see if that one use has seen that mail id already. I will keep punching at it.

[Søren Dyhr]

No but each mail can have a multilinekey telling which employee, needs to get informed or recieve a mail. This makes a table less to deal with just have a record for each person, and have the multiline that recieves the toggling between bold and plain. This gives two multiline keys 1) the reader list and 2) the togglelist.

Tell me if you need a hand!

--sd

p.s. I just stumbled over this alternative approach:

http://www.kevinfrank.com/download/county-highlight-in-portal.zip

Edited August 24, 2006 by Guest
the P.S.