Table link and multiple combo box usage

[miguelsbpgj]

Could someone help me ?

I'm really experiencing problems ...

I will need those tables : tblCostumers , tblSystems , tblRepair

tblRepair will link through its unique CostumerID primary key, as you said but,
is it through a foreign key ?

I will need a "tblSystems" too, witch will contain all the details about the computer systems each costumer has at home or work.
How to link this to each costumer ?

Another doubt :

At the "tblReapir" I'm thinking to use combo box to select all repair procedures like combo boxes follow, so future statistical analysis will be made easily :


Replacements combo box

HARD DISC
DVD
CD
POWER SUPPLY
. . .


Software combo box

WINDOWS
EXCEL
WORD
ANTIVIRUS
. . .

Problem is : A repair service may need several
items to be selected from the same combo box
( in example : Replacements -> HARD DISC + POWER SUPPLY and
Software Installation -> WORD + ANTI VIRUS ) but each new item
I select from the same combo box must be stored on a different field on the repair table ( If I'm thinking well ) .
As each combo box is located into its own field and associated with it, how to do this ?

Can I make appear a new combo box at the right side of each one I use,
so I will have so many combo boxes from the same type as my needs of selecting new items from the same type ?


My idea is :

1. Initial visible combos are:

Repair Software

2. I select a item from repair and visible combos are :

Repair Repair Software

4. I select a item from Software and visible combos are :

Repair Repair Software Software


Will this solution create combo boxes that although they are necessary for one repair service, they may be unnecessary to other repair services, being there anyway, as different repair services share common columns ?

Anyway, if this is a valid idea, how to implement this ?

Or ... Is that another way to approach the problem ?



Lots of thanks in advance,

Miguel Garcia