Table A has many columns. 2 particular columns are “Brand” and “Product name”. When an user adds data to table A, the user needs to select a brand (dropdown list) in column “Brand” and select a product name (dropdown list) in column “Product Name”. If product name is not found in column “Product Name”, the user can click “New” to add. Thus, another form (Table B) pops out. Table B has 2 columns (“Brand” and “Product name”). I want the value of “Brand” in Table A (the value selected by the user) to be the initial value of “Brand” in Table B when Table B pops out. How to write the expression? Thank you very much.
LinkedIn
Twitter
