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

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

Value lists from another table

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

Contents

  Value lists from another table Mushabab <malmurayeh@saudimedicine.net> - 2012-12-01 05:35 -0800
    Re: Value lists from another table Mushabab <malmurayeh@saudimedicine.net> - 2012-12-02 03:47 -0800
      Re: Value lists from another table clkaufmann@gmx.ch (Christoph Kaufmann) - 2012-12-02 14:03 +0100
      Re: Value lists from another table Bill <bbcollins@earthlink.net> - 2012-12-02 15:56 -0500
    Re: Value lists from another table Mushabab <malmurayeh@saudimedicine.net> - 2012-12-02 10:09 -0800

#1086 — Value lists from another table

Hi ALL ;

I want to create an inventory. I need many fields to have data from a predefined value list from another table which has many fields each with value list. How to make the releashinship between those two tables so once the data retrieved in the main table it will not be changed even the list in the other table deleted or altered

Thanks

Mushabab

[toc] | [next] | [standalone]

#1088

Hi All !

It seems I was not clear enough hence I will rephrase my enquiry and waiting for your expert advices!



I want to have an inventory for storage (medical equipments). In the main table I have many fields , I want some of these fields to be filled with data in another table and to be displayed as a menu list ( value list of all the records in the fields of the other table ) so the data once entered will be consistent all the time .

e.g. 

in parent table :

field : category 

in child table 

field : category : with records : A, B, C, D, E, 

so once I want to enter data in field category of parent table it will lock up to all the records in field category of child table and display them as menu list

I hope I could make it clearer now 

Cheers!


On Saturday, December 1, 2012 4:35:01 PM UTC+3, Mushabab wrote:
> Hi ALL ;
> 
> 
> 
> I want to create an inventory. I need many fields to have data from a predefined value list from another table which has many fields each with value list. How to make the releashinship between those two tables so once the data retrieved in the main table it will not be changed even the list in the other table deleted or altered
> 
> 
> 
> Thanks
> 
> 
> 
> Mushabab

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

#1089

Mushabab <malmurayeh@saudimedicine.net> wrote:

> I want some of these fields to be filled with data in another table and to
> be displayed as a menu list ( value list of all the records in the fields
> of the other table ) so the data once entered will be consistent all the
> time .
> 
> e.g.
> 
> in parent table :
> 
> field : category
> 
> in child table
> 
> field : category : with records : A, B, C, D, E,
> 
> so once I want to enter data in field category of parent table it will
> lock up to all the records in field category of child table and display
> them as menu list

Create a value list and have it display the values in the field category
of your parent table. Once created, you can use this value list
everywhere in this file. Just add it to the field object of the layout
where you need it.

-- 
Christoph Kaufmann
http://clk.ch

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

#1092

In article <c0d29cb1-60fd-4bbe-8ec3-23339995cb3c@googlegroups.com>,
 Mushabab <malmurayeh@saudimedicine.net> wrote:

> Hi All !
> 
> It seems I was not clear enough hence I will rephrase my enquiry and waiting 
> for your expert advices!
> 
> 
> 
> I want to have an inventory for storage (medical equipments). In the main 
> table I have many fields , I want some of these fields to be filled with data 
> in another table and to be displayed as a menu list ( value list of all the 
> records in the fields of the other table ) so the data once entered will be 
> consistent all the time .
> 
> e.g. 
> 
> in parent table :
> 
> field : category 
> 
> in child table 
> 
> field : category : with records : A, B, C, D, E, 
> 
> so once I want to enter data in field category of parent table it will lock 
> up to all the records in field category of child table and display them as 
> menu list
> 
> I hope I could make it clearer now 
> 
> Cheers!
> 
> 
> On Saturday, December 1, 2012 4:35:01 PM UTC+3, Mushabab wrote:
> > Hi ALL ;
> > 
> > 
> > 
> > I want to create an inventory. I need many fields to have data from a 
> > predefined value list from another table which has many fields each with 
> > value list. How to make the releashinship between those two tables so once 
> > the data retrieved in the main table it will not be changed even the list 
> > in the other table deleted or altered
> > 
> > 
> > 
> > Thanks
> > 
> > 
> > 
> > Mushabab

Sounds like you need a dynamic value list, which is created from a field 
in a table. The dynamic value list can be defined based on one or two 
fields. Also, you can define a calculation field in a table based on a 
concatenation of several fields in the same table, and then use the 
calculation field to create the value list. The latter method only works 
if the calculation field is in the same table as the fields used to make 
the calculation, as the field in the value list has to be indexed in 
order to work.

You use the terms "main table" and "child table" but then describe a 
relationship setup that suggests a that what you are calling the Child 
table is really a data source table for the "main table"

Sounds like the field in the "main table" should be a text field, that 
is filled by the chosen value from the value list, and is not actually 
related to the data source table. That way the value in the main table 
will not change even if the data in the source table changes.

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

#1090

On Saturday, December 1, 2012 4:35:01 PM UTC+3, Mushabab wrote:
> Hi ALL ;
> 
> 
> 
> I want to create an inventory. I need many fields to have data from a predefined value list from another table which has many fields each with value list. How to make the releashinship between those two tables so once the data retrieved in the main table it will not be changed even the list in the other table deleted or altered
> 
> 
> 
> Thanks
> 
> 
> 
> Mushabab

Thank you Christoph Kaufmann for your helpful advice!

[toc] | [prev] | [standalone]

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

csiph-web