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

Groups > comp.databases.filemaker > #782

Re: contrainted insertion and fill automatically

Show all headers | View raw

Le vendredi 13 avril 2012 19:39:11 UTC+2, Christoph Kaufmann a écrit :
> Andy <andyrichard97@gmail.com> wrote:
> 
> > I have 2 tables:  Order (table 1) and  Products (table 2)
> > 
> > In Order, there are 2 fields :  Field_A  and  Field_B
> > in Products, there are 2 fields : Name and Description
> > 
> > Now, I would like to create a new record,  the Field_A  must take only
> > the value
> > of Name and then displays automatically in Field_B the value of
> > Description.
> 
> Set up a relation OrderPRODUCT based on order::Field_A = products::Name
> 
> In Order::Field_B, make a calculation List ( OrderPrduct::Description )
> 
> The List function is available in Filemaker 9 and later.
> -- 
> http://clk.ch

Thank you for the answer :-)

the second part is ok, Field_B takes the value of Description.
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.

Best regards,

Andy

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