Inherit from dependency.

[Flashbond]

Hi guys.



I have a simple question. The only thing I don't know is if it's possible in Access.
Let say I have 3 tables. billing_info, product_info and the_bill (not the one in kill bill)
billing_info's and procut_info's PKs are FKs in the_bill table. the_bill table has also Address, ProductName, Price and Date fields.
What I want is to make the the_bill table pull only these Address and ProductName fields data according to that record's FK inheritances.
I know how to make the referential integrated relation but I don't know how to make such auto filling by the referance.

What I want to do is to make a printable invoice from the_bill table.
OR
Would you suggest me to delete Address and ProductName fields from the the_bill table and call them directly from the parent tables by FKs?

Thanks a lot!

[Flashbond]

And one more related question,
Let's say I have another table called purchased_products. This table has a bill_ID field which is a FK of the_bill table'ss PK and may have dublicate values.
I want to calculate the_bill's Price field with the related FKs in purchased_products table.
Pufff, it is so hard to setup in my little mind. OK, forget about the product_info table.
While I am talking about the_bill table; I want to get the Address data from its parent table billing_info AND ProductName and Price data from it's child table purshased_products.

[Flashbond]

Example:
How to make;
The orange Address field gets data from parent table and red "Total" field calculates grantotal from its child table.
??

Customer_ID(PK)	Name	Address
6	Anakin Skywalker	Tatooine
+	Bill_ID(PK)	Customer_ID(FK)	Address	Total
	1683	6	Tatooine	500$
	+	Product_ID(PK)	Bill_ID(FK)	ProductName	Price
		23	1683	Super Cooled Galactic Laser Shield	200$
		28	1683	Turbo Boosted Hyper-Jump Engine	300$