Need help with MY database

E

Ernie

I got three tables: Company, Payments and taxation
fields in:
Company: CompID
CompName
ContactName
ContactTitle
CompAddress
CompPhone
CompFax
HomePage

Payments: PayID
TaxID
Amount
Reciept
Date
Balance

Taxation: CompID
TaxID
ConTax
LateFee
EnvLevy
OutMonths
AccumInt
ComTaxInt
TotalDue

My database is basically a calculation of the fields in
Taxation table to give totalDue a sum. Every payment made
should be subtracted from the totaldue in taxation table.
I need to figure which is the best way to relate the
tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Identical Field Values from Form A to Form B? 14
Need help with form 0
What’s the best way to implement “Current Balance” ? 1
Duplicate record 1
I need help! 2
Need help changing a database 5
Trouble shooting a query 1
Need Final Balance Formula for all Patients! 3

Top