Calculated Field Look Up
Calculated Field Look Up
I have a table of 120,000 fixed records that are used in a formula based field.
The record relevant to the user is filtered through a series of dropdowns on a local database application.
Field 1 Choose A and this then gives you Field 2 with Choices of A1, B1, and Choose A1 and Field 3 gives you a choice of A2, B2 etc.
When you finally identify your record from the drop downs i.e. record A-A1-A2 the tool then produces a calculation using the number fields attached to the A-A1-A2 record and your enter.
Are those 120,000 fixed records treated as "database" entries for the purposes of pricing or are the database records the physical entries by the user
i.e. Fred Smith XYZ Street has selected A-A1-A2 and he has entered 1000, which is multiplied by the 20 from the number field associated with A-A1-A2 and so his calculated value is 20,000