Forum Discussion

NeveLeem's avatar
NeveLeem
Qrew Trainee
9 years ago

Find match for 2 fields in different table, then recognize in 3rd field

I have two tables: task and reports. In each table, I have task numbers. Basically when a task is created, it gets worked on. But in order to assure it is worked, I need to be able to match these two ...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
May I ask why you are duplicating that task number to a different table?  Can you not do the reporting on that task directly?  I have a feeling the general set up might need re-visited.

Can you describe the actual use case a little more, and your table relations?