Lookup / Paste Data Functionality

[Richard Kayton]

In Filemakerpro there is the ability to lookup and PASTE a value into a
field? For instance, in an order entry system it would be nice to paste the
current price of a product into the order. Since prices can change a simple
lookup will not work.

So is there a way to do this?

Any assistance will be most appreciated.

 

[Allen Browne]

Use DLookup() in the AfterUpdate event procedure of the combo box where you
choose the product to look up the current price in the product table and
assign it to the price in the current form.

For an example, open the Northwind database, the order details subform, and
see the code attached to the AfterUpdate event procedure of the ProductID
combo.