If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste/Lookup Functionality
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. |
#2
|
|||
|
|||
Paste/Lookup Functionality
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) -- ~Your Friend Chris http://myvbastuff.blogspot.com/ thinking out loud "Richard Kayton" wrote: 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. |
#3
|
|||
|
|||
Paste/Lookup Functionality
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') -- ~Your Friend Chris http://myvbastuff.blogspot.com/ "Richard Kayton" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|