Stats

  • Locked Locked
  • Replies 7
  • Subscribers 165
  • Views 16065
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Adding Multiple values to single field in CIS database

nandikkara

Hi,

I'm Using excel as my part database. I have to add two manufacturer part numbers in a single field named "MFGP/N". So When I try to place the symbol, I can choose which part number need to give like selecting one from multiple symbols. Is there any possiblitity to do so?

  • nandikkara
    in reply to oldmouldy

    I think this will help.

    I can able to choose symbols like the figure you posted. Mfg part number, EN etc I cant do it like that.

  • oldmouldy
    in reply to nandikkara

    OK, you have a Base Release so it might be worth contacting whomever you got the software from about getting up to date, s035 was issued at the end of February. OK, the Part Number, required field, specifies one, and only one, part, that is turn is going to have exactly one manufacturer. If you want different manufacturers, they are different parts, if you want different suppliers of the same manufacturer, you need a relational database, or more fields, to support the alternate suppliers. Whilst "a" capacitor might be considered to be the same thing, a capacitor from AVX and a capacitor from Kemet (just to name two vendors) are not the same thing, especially if you want any traceability of supply.

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.