How to automatically fill a field between different tables "autofill"?

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
satokoba
User
Posts: 11

How to automatically fill a field between different tables "autofill"?

Post by satokoba »

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


arbei
User
Posts: 9384

Post by arbei »

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


Post Reply