Hello,

I am working on a database for my company, I am working on our project table, which has projects listed by year with a related table of Contacts which can be related to a number of project years. I have a relation setup

Projects_by_Year:Year = Contacts:Years

I then setup a checkbox set showing project years (Use Values from Field:Projects_By_Year:Year), therefore if the year is checked that contact is related to that years project. What I am trying to do is uncheck a year via a script, where someone may want to remove that contact for a particular year but not delete the record all together, for example say we have 2007, 2008, 2009, 2010; 2007 and 2008 is checked, I want to have a button that says remove contact and when pressed the script will uncheck the 2007 value

hope this makes sense, thanks!

Try:

Substitute ( "¶¶" & checkbox & "¶¶" ; [ ¶ & item & ¶ ; ¶ ] ; [ "¶¶" ; "" ] )

Excellent!!! THANKS! Worked like a charm!