Received: by 10.224.184.11 with SMTP id ci11mr2769433qab.1.1354368901895; Sat, 01 Dec 2012 05:35:01 -0800 (PST)
Received: by 10.49.86.106 with SMTP id o10mr1139119qez.14.1354368901833; Sat, 01 Dec 2012 05:35:01 -0800 (PST)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!i9no483471qap.0!news-out.google.com!gf5ni37485490qab.0!nntp.google.com!i9no483466qap.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.filemaker
Date: Sat, 1 Dec 2012 05:35:01 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.230.22.170; posting-account=mOigcwkAAACBNsugmiq82f029q955jnF
NNTP-Posting-Host: 213.230.22.170
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c0fa1991-7dcf-40dc-8e7d-e5e1cdff0703@googlegroups.com>
Subject: Value lists from another table
From: Mushabab <malmurayeh@saudimedicine.net>
Injection-Date: Sat, 01 Dec 2012 13:35:01 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.databases.filemaker:1086

Hi ALL ;

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

Thanks

Mushabab