Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: Andy Newsgroups: comp.databases.filemaker Subject: Re: contrainted insertion and fill automatically Date: Fri, 13 Apr 2012 13:08:05 -0700 (PDT) Organization: http://groups.google.com Lines: 48 Message-ID: <32962566.215.1334347685746.JavaMail.geo-discussion-forums@vbjl30> References: <1kii939.1dipzyq1inudcN%clkaufmann@gmx.ch> <927182.65.1334342402233.JavaMail.geo-discussion-forums@vbvf19> <9dugo71gd4els7525ckqgdf70qgkph2che@4ax.com> NNTP-Posting-Host: 188.61.119.160 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1334348031 18130 127.0.0.1 (13 Apr 2012 20:13:51 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 13 Apr 2012 20:13:51 +0000 (UTC) In-Reply-To: <9dugo71gd4els7525ckqgdf70qgkph2che@4ax.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=188.61.119.160; posting-account=KmJyZQoAAABJAACNA08rwADV6guhSvBR User-Agent: G2/1.0 X-Received-Bytes: 2566 Xref: csiph.com comp.databases.filemaker:784 Le vendredi 13 avril 2012 21:08:36 UTC+2, Christoph L. Kaufmann a =E9crit= =A0: > Andy schrub am Fri, 13 Apr 2012 11:40:02 > -0700 (PDT) in comp.databases.filemaker: >=20 > > the first part Field_A has any contrained of the value of Name !!!=20 > > (if the value of Name is correct in Field_A, it's ok for Description).= =20 > >=20 > > How can I limit the value of Field_A ? it must take only value of Name. >=20 > Value List, then Drop down. I'm not sure I understand the problem, > however. Rephrase en fran=E7ais.=20 > --=20 > Christoph Kaufmann > http://clk.ch It is not easy for me to explain :-) so I will write an example: Table_2 ( name, description) Name Description AAA Television BBB Radio CCC Printer ... ------------------------------------- Table_1 ( field_A, field_B ) field_A Field_B AAA Television ok but when I put AA in field_A , it is accepted ! (Field_B has no value) I would like that field_A accepts only values in "Name" (AAA or BBB or CCC and nothing like AA or A !)=20 I can not use the value list because field Name has already values that I n= eed. Hope that you can understand what I want to explain :-) Thanks for you help