I will try to explain better! Sorry.. It is hard to explain the background of why we need what we need. Two tables currently only have one to many cross-table relationship between the two tables. (If this is not necessary I can get rid of this)
There are 2 tables with different fields (only a few related fields) for different roles. So I guess to explain what I need is...
Basically, I want to be able to look-up if that field 1 value exists in field 2. And if that value exists, then I want to create a formula checkbox for "if [task number 1] = [task number 2], TRUE, FALSE"
What I am picturing is a table with three fields. First would be stocked task numbers, followed by reported task numbers. Then a "Purchased" formula checkbox. To give you a visual idea, here is what I am picturing in my mind.
- Field 1[Task Number_Stock] || Field 2[Task Number_Report] || Checkbox [Purchased Item]
- 2017-ABCD || 2017-ABCD || Checked
- 2017-XYZ || <> || not checked
- 2015-DEF || 2015-DEF || Checked
Hope this gives a better idea/picture of what we need....
