Link to home
Start Free TrialLog in
Avatar of Grant Fullen
Grant Fullen

asked on

Estimateing .mdb database plan.

I am writeing a estimateing application.
I have a .mdb database.
Table:= Customer Info
Table:= Estimates.
I need a game plan to make an estimate useing the tables.
So here is what i have now.
Enter in all the customers Name,Add,Phone,CarInfo in the Customer Info.

Now I do all my math , Sums, Tax, Total in the Estimates table.

Sine there may be 10 to 20 lines to calcuate in the estimates table i can not add all this info in the customers table.

Question: How can i get my customers info tied to the Estimates table properly so i can add/edit/ save info ?
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Grant Fullen
Grant Fullen

ASKER

Diver I understand Customer => Estimates => EstimateDetails => Items
Mine will be CustomerInfo=>Estimates=>CompletedEstimates.
I do not know how to do this realtions in delphi....... But I get the basic ideal.
Both Apply