Auto-lookup based on calculation? 
Author Message
 Auto-lookup based on calculation?

How can I perform the following function without resorting to dynamic
value lists?

2 databases Prices and Invoices.

Prices: record contains description field , on-site price, and carry-in
price fields

In invoices database I want to select from a value list of "price
descriptions"-pulled from "Prices database" but if I select a field
called "location" I want it to calculate whether or not to lookup the
on-site price or the carry-in price.

If the user clicks location back to "carryin" then all the prices in
the repeating price fields - re-lookup the carry-in price.

Thanks in advance for any help.

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 11 Sep 2002 03:00:00 GMT
 Auto-lookup based on calculation?

If I'm understanding this correctly you should be able to create an unstored
calculation field in your invoices database.  Use an IF statement to decide the
current "location" and display the associated price from the prices database.
-Don-
Quote:

> How can I perform the following function without resorting to dynamic
> value lists?

> 2 databases Prices and Invoices.

> Prices: record contains description field , on-site price, and carry-in
> price fields

> In invoices database I want to select from a value list of "price
> descriptions"-pulled from "Prices database" but if I select a field
> called "location" I want it to calculate whether or not to lookup the
> on-site price or the carry-in price.

> If the user clicks location back to "carryin" then all the prices in
> the repeating price fields - re-lookup the carry-in price.

> Thanks in advance for any help.

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Fri, 13 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Auto-update a number field w/ Auto-Enter Calculation

2. is it possible to lookup a field value, based on a lookup that is based on another lookup, in a repeating field?

3. Lookup's, Calculations & Repeating Fields

4. calculation changed to lookup fails

5. Help with lookup in a calculation

6. auto lookup

7. SQL Server auto calculations

8. Auto Lookup

9. How do you auto open a table lookup?

10. How do you auto open a table lookup?

11. auto-lookup?

12. Auto-entering Date Calculation Question


 
Powered by phpBB® Forum Software