Database

[dragonlight]

I have created a tracking program using access, the main tracking page contains name, address, phone numbers, computer information etc. I also have two fields that I insert the problem, and then the fix, then that is printed out to give to the customer. whenever the customer brings their computer back in for service, I do a search for their account, and it brings up all the pre existing info. There last problem and cure are still in there... I would like to find some way if it's possible to make this dump the items to a database for each customer in case I want to go into it again and look at past events. Then the next time I open their account, the problem and cure fields are empty, but their data past problem and cure will still be in there.....
I almost have this program or database to where it will do everything that I want it to do.

Any help would be very much appreciated.
Thanks
chad

 

[Fuga]

Sounds like an 1:N relation, where 1 computer can have many repairs(?).

I would set up your db with at least two tables.

tbl1
computerID (autonumber(PK))
info
info
info


tbl2
computerID(number(FK))
arrival date
problem
action
finish date

In the first table, you have general information about the computer/customer. In the second you have information about
every service. Then you link the two tables with the computerID field.

Fuga.