table related to a field

[miguelsbpgj]

Hello

Could you help me ?

My problem is :

I'm developing a ms database for the a "repair service" .

I created a table witch contains basic data from customer, including its unique ID number (key field), name and contacts ...

Now I need to store the "repair service" data from each costumer ( its time consumption, replaced materials...) in a separate table but, If I'm thinking well, I must have a table for each costumer so, I will need to link each individual "repair service" data table from each costumer to each costumer itself.

Do you know how to do this ?

Lots of thanks in advance,

Miguel

 

[Matt Greatorex]

You don't need a separate table for each customer. You need one to store details of all customers (address, tel no, discout rate if applicable, etc.) and one to store details of all work done. You would then link the two via the unique customer id number.

One row in the work table would relate to one job or - if you did multiple separate pieces of work for the same job - to one part of the job. You could include an invoice or job number field to allow you to 'group' data together, meaning that you could then query this table and find all work carried out for one specific job.

Is that the sort of thing you're trying to do?

 

[miguelsbpgj]

Table link and multiple combo box use

Table link and multiple combo box use

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

 

[seth_belgium]

You could change the combobox-settings to Multiple, that way one can select multiple items from the box by keeping the Ctrl-button pressed in.

 

[miguelsbpgj]

Changing combo box setting to multiple

You could change the combobox-settings to Multiple, that way one can select multiple items from the box by keeping the Ctrl-button pressed in.

Sorry but I don't know how to chage combobox-settings to Multiple .
Could you help me ?