Linking Tables together

[britta]

Ok, I am going crazy over this one.
I have two tables. One table holds all the inventory transactions for several different days per product (called Transaction History). While the other table holds product information per purchase order (called Inventory Transaction). So in my forms you can enter what product you want in the purchase order, this will then go directly to the Inventory Transactions, which is a subform of my product form. I then have a subform of my subform which holds transaction history.
What I want is for in my Inventory Transaction table for it to sum up a field and give me the total. I want it to add up all the items ordered for that one product (which is broken down in transaction history) and give me the total number in inventory transaction.

Can a table create a sum? If not how else to I get the two tables and forms to do what I want them to. I have it all expect getting the totals in the one table.

I hope this makes sence and that someone can please help me.
Thanks britta

 

[Jeff Boyce]

Britta

In Access, tables are "buckets-o-data". They "do" very little with it.

Queries, on the other hand, allow you to associate tables' data (provided
there is a common key field in the tables).

Forms, as you've found, display data.

I am a little confused by your description, however. If you have a main
form for your purchase, a subform for your Inventory, and a sub-subform for
Transaction History, how does "product" fit in?

And are you saying that your "Transaction History" only holds "inventory
transactions for several different days"? Where's the rest of the days'
transactions?

Perhaps you could post a description of the table structure you are
using...? Something like:

tblFirst
FirstID
Attribute1
Attribute2
...

tblSecond
SecondID
S_attribute1
...


--
More info, please ...

Jeff Boyce
<Access MVP>

Ok, I am going crazy over this one.
I have two tables. One table holds all the inventory transactions for

several different days per product (called Transaction History). While the
other table holds product information per purchase order (called Inventory
Transaction). So in my forms you can enter what product you want in the
purchase order, this will then go directly to the Inventory Transactions,
which is a subform of my product form. I then have a subform of my subform
which holds transaction history.

What I want is for in my Inventory Transaction table for it to sum up a

field and give me the total. I want it to add up all the items ordered for
that one product (which is broken down in transaction history) and give me
the total number in inventory transaction.

Can a table create a sum? If not how else to I get the two tables and

forms to do what I want them to. I have it all expect getting the totals in
the one table.