Hi
我現在自學 Access, 覺得這個 software is very useful, interesting, but very difficult....

但有個問題好想知道 "Access" 可唔可以做到 :

假設我有兩個 Tables, 一個 name as "Customer", 另一個 name as "Part".
Table "Part" has the field "Part #", "Part Description", "Quantity", "Unit Price", "Total Quantity", etc....

Table "Customer" has te field "ID", "Customer Name", "Address", "Phone #", "Part #" "Part Description", "Quantity", Unit Price", etc.....

我想知道我可唔可以在 Table "Customer" 用 Table "Part" 的 "Part #", "Part Description", "Quantity", "Unit Price", 而用左之後, Table "Part" 的 field "Total Quantity" 會減左我的 use quantity?

如果可以, 有沒有高手可以教我點做?  

還有一個問題, 我可唔可以在 Table "Customer"裏整個好似 Excel 的 table, 可以 input 數個唔同的 "Part #" 等等, 而又會反映在 Table "Part"

我好似表達得好亂, 好 confuse, 希望你們明我的問題啦, thanks!