but in fact for example: pc reception have two memory module but i do the gestion of the individual pieces too for example in a table i have id name ref hs? 1 sdram256 22055 True 2 sdrram512 22056 True so i need to keep the informations of the reference too 2005/5/19, Tom Rogers <trogers@xxxxxxxxxx>: > > 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 > > -- Ne sois pas trop prompt en parole réfléchis aux conséquences de tes mots. Derrière un pc il y a toujours un humain
