Changing ID in multiple Tables

[thunderbolt1164]

I have been building a DB for a while and have broken the tables down to 4 different tables using 4 differnt ID's:

DropOffs ----- DropOffID
PickUps ----- PickUpID
Sales ----- SaleID
Repairs ----- RepairID

Is it possible to change each ID to 1 common ID like: TransactionID ?
Now that I think of it I should maybe be asking, is it adivisable to do this?

The reason I ask is I want to be able to link them in a query for a report showing the total of each group with a sum total of all income.

 

[ajetrumpet]

DropOffs ----- DropOffID
PickUps ----- PickUpID
Sales ----- SaleID
Repairs ----- RepairID

Is it possible to change each ID to 1 common ID like: TransactionID ?
Now that I think of it I should maybe be asking, is it adivisable to do this?

The reason I ask is I want to be able to link them in a query for a report showing the total of each group with a sum total of all income.

No you shouldn't do this, for the main reason of creating a query. If you do change the names of fields in every table, you will most likely run into an error message when building a query that says something similar to this:

"TransactionID" referred to in your expression could refer to one or more fields in your query

You want to avoid things like that.

 

[thunderbolt1164]

Thanks, That is what I thought so I have started over
I now have 1 Transaction Table
1 Transaction Details Table
and have use Query to make up the 4 different Forms I require, but now when I build a Query for SubTotal and insert it in the Form..It comes up a Blank Form.
Could it be because there isn't any data for the Query to Sum up?

 

[thunderbolt1164]

That did not work either. I entered some data in DropOffs but when I went into PickUps it was listed there too.

I have a different DB that seems to almost work except that it does not have a summary page that works.

What I would like is some way to pull data from 5 different Queries (that aren't linked) onto 1 Report somthing like:

Total DropOff Income.................$$$$.$$ (DropOffID)
Total PickUp Income..................$$$$.$$ (PickUpID)
Total Sales Income....................$$$$.$$ (SaleID)
Total Repairs Income..................$$$$.$$ (RepairID)
____________________________________
Total Income............................$$$$.$$
Total Expenses........................-$$$$.$$ (ExpenseID)
___________________________________
Grand Total..............................$$$$.$$

Is there any way to do this?