Multi query issues for a combo box

[munkeyroot]

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

 

[plog]

i hope this makes sense best way i can explain it

Not really. The process of setting up tables for a database is called normalization (https://en.wikipedia.org/wiki/Database_normalization). Read up on it and use it to set up your tables.

A simple overview is that tables represent objects. You mentioned parts and orders-2 distinct entities that would require 2 tables. Now, if you wanted to put them in a relationship such that an order is comprised of many parts (one-to-many), you would need a third table--OrderedParts--that would tell you what parts go with what orders.

Then however you metnioned systems. I really don't grasp that type of object. Could you better explain it?

 

[munkeyroot]

Hi Plog
thank you for your message, i shall give that a read up fella.

ok so basically i am trying to stream line the item select process as we have many products that relate to each other and that can be used with in conjunction with.

so we have a system type which is just another category really to help speed up the selection process when setting up an order for a client.

so it is just "system" ,"category", "part type", "item description"

hope this helps
thanks again for your message
Munk