I have a table Data Base with two Columns Article and Code Article; and another table InputOutput of stock which has several columns including Columns Article and Code Article. To make an entry or an out stock, I select the data already recorded in the Database table. During the selection if I choose the Article in the drop-down list, I want the selection field of the Article code which corresponds to this selected article to be filled automatically. EXAMPLE: Database table. Column Article contains Article 1 whose Article Code is A1. In the InputOutput table, if I select Article 1, the application suggests me in the Article Code field, A1.
Have you checked out Dependent Dropdowns