Display Records

[kim40]

I have two tables a purchasing table and a payment table for clients. I have a revenue field in both tables. How do I get my Revenue from my purchasing table to display in my Payment table?

 

[John Big Booty]

Have a read of this article.

If your tables are structured properly there should be no need to store that value in both tables, if indeed you do need to store it at all.

 

[kim40]

You talk about properly structured tables. How do I know when my tables are properly structured. Honestly I know nothing about databases and I am teaching myself as it forms part of the job.

Thanks

 

[John Big Booty]

A good DB is built on a strong table structure and to achieve this your data needs to be properly Normalised. Also have a look at some of the many tutorials on the subject.

You might also get some inspiration from the data models available here.

 

[kim40]

thank you this really helps

 

[kim40]

I have three 3 tables company, payment and import table.
The import table consist of the following fields ImporterID, Vessel, Date(vessel arrival date),Item(there ore only 4 items) and the Amount owed for each item.
I have the payment table which have the following fields PaymentID.ImporterID, Importer Name,Amount Owed,Amount paid, date paid, receipt no. and Balance
Do I need the amount Due in both tables, Because I need to know how much the companies owe every month(this database is meant monitor imports of three items and the payment of the tax