Programming and Setup Question

[tjc240e]

I am looking for schemes on "How would you do the following...."

You have 4 databases: Individual, Account, Money, and Split.

Individual database has Ind_ID, First, Last Name, Address, City, State, Zip
Account database has Account_id, Account_Name
Money database has Money_id, Ind_id, Date, Amt, split_id, Account_id
Split database has Split_id, Date, Amt, Account_id

Individual is linked to Money by IND_ID
Money is linked to Split by Split_ID
Money is Linked to Account by Account_ID

Now you want to create reports on the Money table ...

Would you create temp tables to pull all the information together into one location and then report on that newly generated table?

My problem seems to be that i cannot pull the information i need into a report directly from the databases.
Would MemSets or DynaSets be something to look into and consider?

How else would you do this?

TIA

 

[Glenn9999]

I'm not sure what you're getting at. If you only want to report on one table (money) you shouldn't have an issue. But in SQL terms, if you are wanting data from the other tables, you would want to do a JOIN.

For that matter, how are you trying to access this database?

 

[tjc240e]

Oh sorry, basically what i am trying to report on is a combination of all 4 tables...
Money is the main table.
I need to pull the Individual Information for the report.
I also need to pull what account the money is going to...
Also the Money entry might be split between two accounts and that is where the split table comes in

My tables are all DBF tables.

I was programming this in Delphi 7 and using the Rave Report writer to generate the reports.