On Create/Modify have one filter perform a setfield on that same form that does a search for the same Name, and Cell != $Cell AND Cell != $NULL$....then have a second filter that fires if a record was found...and throw an error....or take some other action if you wanted to.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, August 26, 2008 4:01 PM To: [email protected] Subject: How to block that a user belongs to more than one group (It's not the User / People form) ** I'd like to know if someone has an idea of how I can block that a unique user does not enter in more than one group (cell). I have a Form that is called "Employee".. This form has few fields... (but only 2 fields is important to us - Fields: "Name" and "Cell"). 1. Name: represents the name of employee. 2. Cell: represents de cell or group that the user is in. This form supports more than one record with Name field "Tadeu", but it can't support that "Tadeu" is in more than one Cell (Group)... For example: If a record of "Tadeu" has "Cell 1" in the Cell field... I would like to block the user to set another record of "Tadeu" with the value "Cell 2" in the Cell field of this second record... (it can stay null or with the same value that was set first) How can I create a logic to do this... I wouldn't like to need to work with Table Loop and/or Guides... But If it is the best choice I'll accept it ... I'd like to hear some suggestions of you.. Thanks so much.. Good evening for all! Att, Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.b r/> http://www.cinq.com.br <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
