Hi, Sorry I did'nt read it well I though you want to create link to inventdim table.
I this can't be done using relationship in table definition either you can make a link to inventdim using inventserialid or you can make a link to inventsum using itemid rgds Mai On Thu, Aug 19, 2010 at 3:10 PM, Mairi <bulukhu...@gmail.com> wrote: > Hi, > > Just make a relation in your new table to inventdim table > and put 2 new normal relation to each field you mentioned below. > > but don't know though why you have to make this link table, is it for > production ? > > Rgds, > Mai > > On Wed, Aug 18, 2010 at 10:15 PM, mgk915 <mae...@alrinach.net> wrote: > >> >> >> How can I specify >> a component of InventDim in a relationship? >> I want to relate a table that has just >> ItemId and InventSerialId >> to >> InventSum, which has ItemId, and InventDim. >> >> - Please help! >> I don't see anyway to create a relationship like this >> on the table-definitions. >> >> >> > >