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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both Apply
ASKER
Mine will be CustomerInfo=>Estimates=>C
I do not know how to do this realtions in delphi....... But I get the basic ideal.