in reply to Re^2: Organizing and presenting a cross-reference
in thread Organizing and presenting a cross-reference

Keep the vendor name and part num separate (cols), but define a compound key on the table (vendor,part_num).
  • Comment on Re^3: Organizing and presenting a cross-reference

Replies are listed 'Best First'.
Re^4: Organizing and presenting a cross-reference
by oko1 (Deacon) on Sep 24, 2008 at 13:56 UTC

    Assuming I've done that, how do I get to searching by part number? Partial key match?


    --
    "Language shapes the way we think, and determines what we can think about."
    -- B. L. Whorf