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
Hi Malcolm,
Thanks for great explanation :)
On Thu, Aug 19, 2010 at 4:53 PM, Malcolm Burtt <
malcolm.bu...@touchstone.co.uk> wrote:
>
>
> Hi
>
>
>
> There’s probably not much to choose between them but…
>
>
>
> If there are lots of records with the same value for field1 then the
> database will
Hi
There's probably not much to choose between them but...
If there are lots of records with the same value for field1 then the database
will need to scan through lots of index leaf nodes to reach all of the records
that you want to select. Since the leaf nodes for itemIdx will be smaller than
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
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 wrote:
>
>
> How can I specify
>
5 matches
Mail list logo
