Select values from another table


#1

Hi,

I have a base set up for my work projects and have separate tables for labour, material, and travel linked to my main projects table so I can sum up total cost estimates. I also have a separate table with the individual services I provide with fields for units and unit cost. Example-painting-unit is square foot and unit cost is $1.00. When adding new items to my “labour” table, I would like to be able to select the “painting” service from my “Services” table and have the “unit cost” field in my “labour” table populate based on the service I selected. Is this possible? Thanks.


#2

Yes… if you already have the tables linked, such that you are selecting the service from the Services table, then you can use “Lookup” fields to pull data out of your Services table that is on the record you linked.

Here’s some more info about Lookups: