Re: problem with multiple fields

Hi, Thursday, May 19, 2005, 6:07:53 PM, you wrote: V> sorry for my poor english, i'll try to be understood V> so i want to represent an informatic parc but have a problem V> for example a pc can have 2 or more memory slot filled how to stock V> the different id in a list in my database and how extract it V> for the moment i just have an external key referencing one memory. V> Have you an idea to help me please? It is probably best to put the individual items in a separate table and link their keys, as an example with 3 tables table items itemid name table item_list pcid itemid table pc pcid location then these could contain items itemid name 1 memory module 2 floppy drive pc pcid location 1 reception item_list pcid itemid 1 1 1 1 1 2 so reception pc contains 2 memory modules and 1 floppy Hope that helps -- regards, Tom