Number Field Populated from Lookup Table

[no1tmorrow]

I have 5 fields in a table. I want them to be Number fields. But I would like them to auto-enter a value from another table during creation. The table is unrelated. This way I can have a user change the values in the unrelated table instead of changing the default value in the Manage Database function. Is there a way to have it grab a certain value? Below is what I am trying to accomplish.

Main Table One Record has all three fields

FabricateCost

InstallCost

ProgramCost

Lookup Table

Type (has Fabricate,Install,Program)

Cost (has a 22 for Fabricate, 40 for Install, 60 for Program)

So one record has Type = Install, Cost = 40

So when a user creates a record I want auto-entered

FabricateCost = 22

InstallCost = 40

ProgramCost = 60

Then down the road when cost's change they can go into the Lookup Table and change the default values.

Thanks

Thom

[mr_vodka]

Why does your main table have 3 fields? Traditionally, a line items table is used with a lookup function to the items table.

[no1tmorrow]

They are separate types of values. Each Line item "Main Table" will have a value for Fab, Install, Program as well as other values. So for this type of table it is not possible to have each value as a separate row.

Thanks

Thom

[mr_vodka]

I believe that you should consider your structure. Take a look at this invoice demo to see how your structure should be. The line items should only be created as needed and the price looked up from the products table.

http://fmforums.com/forum/topic/63425-auto-fill-one-field-with-text-from-two-fields/page__p__300150#entry300150