Reports from mulitple tables

[avarusbrightfyre]

I keep trying to create a report with information from two different tables,
but I run into trouble with the relationships part. I tried using the
auto-numbered contact ID column at first, but when I deleted a record, it
through the whole thing out of whack. Trying to create a reference column in
both tables using the same number for every entry resulted in multiple copies
of data from the table with less entries. I could go through and edit the
reference column with different numbers manually, but that would be really
tedious. Is there a way to renumber the contact ID column when information
is changed on either table?

 

[Gina Whipp]

avarusbrightfyre,

I think we should take a look at your table structure first. Because I am
not sure I understand the readon for 'renumbering'. Your main table with
the AutoNumber is the Primary Key should be 'linked' to the other table
(don't knowname) via Number Long Interger and perhaps set with Cascading
Updates. Is that how it ia set up?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[avarusbrightfyre]

I have two separate tables, neither of them are "main" tables, they just
store different categories of information, income and expenditures. I'm
trying to create a report with information from both tables, but I'm not sure
how to link them so that the information only appears one time on the report.

 

[Gina Whipp]

avarusbrightfyre,

Well, I see a problem... Why are income and expenditures in two seperate
tables? As I said before I think we need to look at the table structure.
Look at it like the foundation to a house... if it's not good the house
will fall down. You CAN write a union query BUT this is only adding more
problems to what sounds like a bad foundation.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm