Paste/Lookup Functionality

[Richard Kayton]

In Filemakerpro (which is what I have used primarily) a field can be defined
as a lookup that pastes the value into the current record. For instance, in
an order entry system it would be nice to paste the current price for a
product into the record without the user having to do it. After all, prices
change over time and therefore a simple lookup will not work.

So is there a way to do this?

Any help will be most appreciated.

Thanks.

 

[vbasean]

if you have a table that contains the current prices of your products
create a combobox with a recordsource of the current price table/query
two rows, the ID/key of the current price/table, maybe it's called [ItemID]
and the second being the identifying feature that shows int he combo box
set the combo box to two columns
set the bound column to the first column
set the width of the first column to 0
the rest to what ever shows your text.
using the combo box after update
me.text_Box_to_update = Dlookup("[name of field containing price]", "[name
of recordsource containing this field]", "[ItemID] = " & Me.combobox)

 

[vbasean]

another thing to keep in mind is that you need two tables.

one with the items and their current price
second, with the line items of your invoices (with a field for 'price',
which is actually 'price at time of sale')