Table master : CustNo. CustName, transaction no
Table transaction : Transaction no, product type, product color,
product range, qty, price and subtotal
Table product range: Product type, Product color and product range
I create a form and subform relatinship, with subform displayed as a datasheet view in order to have 5 rows atmost for each invoice.
In order to ease the user selection in production range, preselected product type and product color could reduce the number of product range for user to select.
That's why in the transaction table, the product range is a query field based on table product range, and product type and product color result input by user for each transacion.
However, it seems ACCESS is not working in this way, as when user switched to next new transaction, the product range of previous transaction also changed. It seems the filter in the product range field could not find any criteria. It seems the control was lost! Any idea??
Sorry that my Access is all in Chinese words that make no sense to post in this thread and hope my problem and wordings could be understood by all of you!! Thanks a lot!!
Table transaction : Transaction no, product type, product color,
product range, qty, price and subtotal
Table product range: Product type, Product color and product range
I create a form and subform relatinship, with subform displayed as a datasheet view in order to have 5 rows atmost for each invoice.
In order to ease the user selection in production range, preselected product type and product color could reduce the number of product range for user to select.
That's why in the transaction table, the product range is a query field based on table product range, and product type and product color result input by user for each transacion.
However, it seems ACCESS is not working in this way, as when user switched to next new transaction, the product range of previous transaction also changed. It seems the filter in the product range field could not find any criteria. It seems the control was lost! Any idea??
Sorry that my Access is all in Chinese words that make no sense to post in this thread and hope my problem and wordings could be understood by all of you!! Thanks a lot!!
