How to automatically fill a field between different tables "autofill"?
Posted: Sat Mar 16, 2024 2:13 am
Hi,
If anyone can help me, if I can do this "autofill" or is there some event?
* tb_sales (A) * tb_prices (B)
id id
id_product ----> product
id_type <---- type (autofill)
In "tb_sales (A)" I use "table lookup" for "tb_prices (B)" and select (A) id_product -> (B) product and I would like to know if I can when making the selection automatically fill in the value of id_type (B)??
tb_sales tb_prices
id_type <----- type
I tried "autofill" but when active and I see the map of fields to associate I don't see the "id_type" field of the tb_sales (A) table.
Thank you so much,
Sato