Linking accross sections

[Ableman42]

Newb question.

I have one large database with seperate tables. Everything is tied to a
customer id #, but each table has different items tracked.

I need a column from one table in another, and it has to retain being
associated with the same customer #.

For instance, one table has customer # and amount due, another table has
customer # and last years total billing. I need one table with cutomer #,
amount due and last years billing.

Help appreciated.

 

[Steve]

Delete the table with last years total billing and you don;t need to put in
the table with amount due. Last years total billing can be calculated in a
query when you need it.

Steve
(e-mail address removed)

 

[Lynn Trapp]

I would start by asking why you are storing this information in separate
tables. Then I would want to know why you are storing the total of billing
for the previous year, since that should probably be something that you
calculate in a query. Can you give us more information?

 

[Gina Whipp]

Ableman42,

You can create a query that includes the tables you need, do not make a
table as it's not neccessary. One with the Customers with a LEFT JOIN to
the other two. Creating a query will give you what you want on demand.

However, it seems as though your table set up is that of an Excel
spreadsheet. You should have one table which includes Billing from all
years, not by year. If you would like some help with that, post your table
structure and we will be glad to assist for FREE.

--
Gina Whipp

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

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