contrainted insertion and fill automatically

Andy

unread,

Apr 13, 2012, 8:44:37 AM4/13/12

to

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

Christoph Kaufmann

unread,

Apr 13, 2012, 1:39:11 PM4/13/12

to

Andy <andyri...@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

Andy

unread,

Apr 13, 2012, 2:40:02 PM4/13/12

to

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

Christoph L. Kaufmann

unread,

Apr 13, 2012, 3:08:36 PM4/13/12

to

Andy <andyri...@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

Andy

unread,

Apr 13, 2012, 4:08:05 PM4/13/12

to

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

Helpful Harry

unread,

Apr 13, 2012, 7:29:56 PM4/13/12

to

In article <1kii939.1dipzyq1inudcN%clkau...@gmx.ch>, clkau...@gmx.ch

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)

Helpful Harry

unread,

Apr 13, 2012, 7:49:40 PM4/13/12

to

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

> Le vendredi 13 avril 2012 21:08:36 UTC+2, Christoph L. Kaufmann a =E9crit=
> =A0:

> > Andy <andyri...@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)

Andy

unread,

Apr 14, 2012, 6:29:31 AM4/14/12

to

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