|
|
Posted by Tom Rogers on 10/02/17 11:16
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
Navigation:
[Reply to this message]
|