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

Groups > comp.databases.filemaker > #778 > unrolled thread

contrainted insertion and fill automatically

Back to article view | Back to comp.databases.filemaker

Contents

  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

#778 — contrainted insertion and fill automatically

Hello,

Someone can help me for the insertion automatically in the fields:

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.

Thank you in advanced of you precious help.

Andy

[toc] | [next] | [standalone]

#780

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

[toc] | [prev] | [next] | [standalone]

#782

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

[toc] | [prev] | [next] | [standalone]

#783

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

[toc] | [prev] | [next] | [standalone]

#784

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

[toc] | [prev] | [next] | [standalone]

#786

In article
<32962566.215.1334347685746.JavaMail.geo-discussion-forums@vbjl30>, Andy
<andyrichard97@gmail.com> wrote:

> Le vendredi 13 avril 2012 21:08:36 UTC+2, Christoph L. Kaufmann a =E9crit=
> =A0:
> > Andy <andyrichard97@gmail.com>  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

You can define the Value List to use values from an field instead of
values manually typed into the Value List window.

If there's another reason you don't want the field formatted as a Pop-up
Menu / Drop-down List, then you could use the Validation options for
Field_A. The easiest way is to still define a Value List that obtains it's
values from the Name field in Table_2., the the Validation Option can
check the data is in that Value List.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#785

In article <1kii939.1dipzyq1inudcN%clkaufmann@gmx.ch>, clkaufmann@gmx.ch
(Christoph Kaufmann) wrote:

> 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.

Why use the List function?? 

Once the Realationship is defined you should be able to just use:

     Field_B  = OrderPrduct::Description
       
where Field_B is either a Calculation field or a normal Text field using
an Auto-enter Calculation.

Helpful Harry  :o)

[toc] | [prev] | [next] | [standalone]

#787

Le samedi 14 avril 2012 01:29:56 UTC+2, Helpful Harry a écrit :
> In article <1kii939.1dipzyq1inudcN%clkaufmann@gmx.ch>, clkaufmann@gmx.ch
> (Christoph Kaufmann) wrote:
> 
> > 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.
> 
> Why use the List function?? 
> 
> Once the Realationship is defined you should be able to just use:
> 
>      Field_B  = OrderPrduct::Description
>        
> where Field_B is either a Calculation field or a normal Text field using
> an Auto-enter Calculation.
> 
> Helpful Harry  :o)

Thank you very much Harry, I do as you've shown and it's ok with
"a Value List that obtains it's values from the Name field in Table_2., the the Validation Option can check the data is in that Value List." and  "Field_B is either a Calculation field or a normal Text field using an Auto-enter Calculation."

Once thank again and wish you an excellent weekend :-) !

Andy

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web