On Submit, query the Employee form where 'Name' = $Name$, and then set the 'Cell' field with the value in $Cell$
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, August 26, 2008 5: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 http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[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___ This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions expressed are those of the author. This message is intended for the addressee(s) only and its contents and any attached files are strictly confidential. If you have received it in error, please contact the sender on the number above. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
