How do i create a value field linked to two other fields

[Guest]

i want to create a value field that looks up and is specific to two other
fields in other tables ??

 

[Joseph Meehan]

i want to create a value field that looks up and is specific to two
other fields in other tables ??

This is a basic function of a database. You normally would use a query
to do this. You need a relationship defined between the primary table and
each child table. In a query you can combine two fields into one if needed.