www.hkvforums.com

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

The data type must be compatible so you can autofill, e.g. you cannot autofill an integer field with string.