munkeyroot
Registered User.
- Local time
- Today, 18:16
- Joined
- Jan 13, 2011
- Messages
- 76
Hi
i don't know if this is possible, i have been looking into organising a parts list, however an orders table needs to access the data.
on the orders table i have fields "system","Category","Part type" "item description" .
the issues i am having is that each Item has the potential to be in the same system type, kind of like a generic item like a battery for instance.
eg System Types Category Part type
Item no|A|B|C|D|E A|B|C|D A|B|C|D|E|F
123521 x x x x x x x x
789352 x x x x x x x x x x
459781 x x x x x x x x x x x x
so if i picked System type A, category C, Part type D, Item description.
all this info has to come from a single table from a parts list. so far i though about splitting each types out and creating a yes/no table out of them, so i could run a query on this but :banghead:
i hope this makes sense best way i can explain it
cheers
Munk
i don't know if this is possible, i have been looking into organising a parts list, however an orders table needs to access the data.
on the orders table i have fields "system","Category","Part type" "item description" .
the issues i am having is that each Item has the potential to be in the same system type, kind of like a generic item like a battery for instance.
eg System Types Category Part type
Item no|A|B|C|D|E A|B|C|D A|B|C|D|E|F
123521 x x x x x x x x
789352 x x x x x x x x x x
459781 x x x x x x x x x x x x
so if i picked System type A, category C, Part type D, Item description.
all this info has to come from a single table from a parts list. so far i though about splitting each types out and creating a yes/no table out of them, so i could run a query on this but :banghead:
i hope this makes sense best way i can explain it
cheers
Munk