Calling a field from another table
How to write QB formula that will pull up the record from another table field? Table 1: Field1, Field2, Field3 Table 2: Field4, Field5, Field6 .[Field6]= .[Field2] ---------------------...
Forum Discussion
Hi Siva,
Could you explain what you are trying to do with that field from another table? Are you looking to pull one value from one record or pull up for example a summary or the most recent record's value, etc?
------------------------------
Evan Martinez
------------------------------
Could you explain what you are trying to do with that field from another table? Are you looking to pull one value from one record or pull up for example a summary or the most recent record's value, etc?
------------------------------
Evan Martinez
------------------------------
- "Are you looking to pull one value from one record or pull up for example a summary or the most recent record's value, etc?"
Yes Evan! this is exactly what I am trying to do. Mimicing Vlookup and based on the value, I want to initialize certain value.
To keep it other way,
If Vlookup from another table is X and if this matches with value in column C(same table), then write Y into the cell.
------------------------------
Siva
------------------------------
