Auto inserting data from another table

PeterSmit · Post by **PeterSmit** » Tue Apr 18, 2017 11:12 pm

I am very pleased to say that this software is fantastic, I have been testing the features some weeks now, thanks also for the auto backup.
I do have one problem that I am unable to solve at this time.
I have two fields with data, one products (name, quantity, type, and price).
And the other table for a customer to select one of the product.
If the client select a product name using the lookup table.
I need the selected product values auto inserted into the customer table (from all the product fields).
I am only able to insert the product (name) and not (quantity, type, and price).
Please help.
The greatest PHP code generator I have seen.

mobhar · Post by **mobhar** » Wed Apr 19, 2017 10:18 am

Please post your tables schema for more discussion.

arbei · Post by **arbei** » Wed Apr 19, 2017 1:18 pm

Read help file topic: "Project Setup" -> "Lookup Table" -> "Auto Fill" and see if it is the feature you are looking for.

PeterSmit · Post by **PeterSmit** » Wed Apr 19, 2017 11:58 pm

Ok, thanks for the reply, I am learning day by day.
Here are the product table fields: productname, unitprice etc.
The same exist in the client table, I need the values from the selected product using â€˜user look tableâ€™ auto insert into client fields when selected.
Can some provide an event example or what should I select.

arbei · Post by **arbei** » Thu Apr 20, 2017 11:51 am

Have you read the help file? It seems "Auto-Fill" feature is exactly what you need.

Read help file topic: "Project Setup" -> "Lookup Table".