Lookup / Paste Data Functionality

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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard Kayton" wrote in message
...
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.