Access 2007: Relational Database Tables
Posted on 2007-10-01
I have a couple of questions regarding creating a relational database.
I created one, but it is incomplete by all means.
First question: Assume that I have two tables (one to Many); The many-side table has a foreign key which is the primary key in another table.
I established relationship between them and integrity constraint.
I first filled the one-side table with data. Then I filled the many-side table.
I thought that when I filled the foreign-key attribute in the many-side table, a dropdown menu (which displays all the input of the attribute in the one-side table was supposed to show up. But it did not.
My question is: How to make the dropdown menu displayed?
My second question is related to the table below:
cash# part# Part_unit_price qty_ordered total_amount
Total_amount refers to the product of part_unit_price and qty_ordered.
How to coduct the product operation in access?
Thanks a lot!