Okay - thank you for your reply! Yes, we have a situation where we need to track items by item# & serial# - we are a manufacturing company and need to keep track of the product's specifications even after it is sold - so I've created a table "InventItemSpecs" - the key-index of which is item# and serial#. At some times it would be helpful to relate to other tables, and inventDimId seems to be one way of doing this - but I've not found it possible to use something like this in defining a relationship - it looks like you can only specify actual fieldnames, not methods on the fields.
- Maeve > 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 <[email protected]> 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 <[email protected]> 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. >>> >>> >>> >> >> >
