Editable List

[dionvk]

I have a table of "Sale" that have column of ID Sale, Cust., Phone, etc and a table of "SaleDetail" that have column of ID Detail, Qty, Price, etc. and im currenty working on making a form for adding products, in general it is already done for, but in adding product form there are some trouble,

1. in the form for adding product (SaleDetail_Form) i check the Auto re-open so it will automatically open the SaleDetail_Form for the next product adding and it will show the list of added product. the problem here is currently im using [ID Sale].[Related SaleDetails] for the list, and i can't edit it, it can only show, the only way to edit is to back first to  Sale_Form (i used a virtual column [Related SaleDetails] with formula: aREF_ROWS("SaleDetail", "ID Sale")) and edit the list from there, is there a way to edit it in the SaleDetail_Form?

nb: I tried to find edit behaviour, but i can't find it also

        

2. in the Product Name, is it possible to search a product for partial match? or if it not, is it possible to adding category first, so it will make easier to find the product?

sorry for my bad explaining, and thanks before.