The bossman says I need to add a certain field into a query and I have yet to figure out out to do it.
I will try and make a trimmed down example.
Table1's columns:
Expand|Select|Wrap|Line Numbers
- myUniqueIDField | (other columns)
Expand|Select|Wrap|Line Numbers
- aUniqueID | LinkToTable1myUniqueIDField | StringColumn | (other columns)
I need ALL columns from all entries in Table1, regardless of if they are in Table2 (left join, nothing big yet)
The problem comes with the extra column he wants.
The contents of that extra column need to be dependant on what is found in Table2 and based on Table2's [StringColumn].
For example some entries in Table2 code be:
Expand|Select|Wrap|Line Numbers
- 1 234 "Action Needed"
- 2 367 "Action Taken"
- 3 234 "Bad Data"
The computed column (for all it matters) could have three possible values then:
It could be blank (meaning it found nothing of use in Table2)
It could say "Action Needed" (meaning it found an entry in Table2 that matches)
It could say "Action Taken" (meaning it found an entry in Table2 that matches)
If this were a one - to - one relationship it would be easy enough to be like Table2.StringColumn and just display it's contents, but there will be many entries in Table2.
So if anyone made any sense of that and has any suggestions I'm all ears.
(It would even be acceptable to me if the extra column contained a concatinated string of all the StringColumns in Table2 that matched that record, I could post process)