Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #784

Re: contrainted insertion and fill automatically

Show all headers | View raw

Le vendredi 13 avril 2012 21:08:36 UTC+2, Christoph L. Kaufmann a écrit :
> Andy <andyrichard97@gmail.com>  schrub am Fri, 13 Apr 2012 11:40:02
> -0700 (PDT) in comp.databases.filemaker:
> 
> > the first part Field_A has any contrained of the value of Name !!! 
> > (if the value of Name is correct in Field_A, it's ok for Description). 
> > 
> > How can I limit the value of Field_A ? it must take only value of Name.
> 
> Value List, then Drop down. I'm not sure I understand the problem,
> however. Rephrase en français. 
> -- 
> 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 !) 

I can not use the value list because field Name has already values that I need.

Hope that you can understand what I want to explain :-)

Thanks for you help

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

contrainted insertion and fill automatically Andy <andyrichard97@gmail.com> - 2012-04-13 05:44 -0700
  Re: contrainted insertion and fill automatically clkaufmann@gmx.ch (Christoph Kaufmann) - 2012-04-13 19:39 +0200
    Re: contrainted insertion and fill automatically Andy <andyrichard97@gmail.com> - 2012-04-13 11:40 -0700
      Re: contrainted insertion and fill automatically Christoph L. Kaufmann <clk@tele2.ch> - 2012-04-13 21:08 +0200
        Re: contrainted insertion and fill automatically Andy <andyrichard97@gmail.com> - 2012-04-13 13:08 -0700
          Re: contrainted insertion and fill automatically HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-04-14 11:49 +1200
    Re: contrainted insertion and fill automatically HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-04-14 11:29 +1200
      Re: contrainted insertion and fill automatically Andy <andyrichard97@gmail.com> - 2012-04-14 03:29 -0700

csiph-web