Calculated field over multiple tables linked by relationship

[gunitinug]

I have two tables:

stock_tbl:
stockID | stockGroup | productRef | quantity



and

product_tbl:
productID | productName | manufacturer | price

I want to create a field by product_tbl.price * stock_tbl.quantity where productID is a primary key and linked to productRef.

I tried googling and it doesn't seem to be possible to create a calculated field over multiple tables. Do I have to use other means like query? Help THX

[John_G]

Do I have to use other means like query?

Yes, you do have to use a query if you are dealing with fields from two or more tables. Actually, as much as possible, calculated fields should only be in queries, not tables.

[orange]

I don't know details of your requirement, but offer this link regarding Prices that may be useful.
Good luck.