I got a big table (8 rows by 20 fields or more) and lets say in every row there are 2 ID fields.
To explain better I got 8 lines and must check 2 IDs per line
If one of the 2 IDs per line matches my string i want to return from that line X fields.
this happens for all 8 rows. And i want to concetrate the results in one place.
One thought was to do a listbox for every column and associate it with the sql column i want. so after my select it automatically shows my results. but since the above will be seperated to like 16 queries, i can not have them all in the same result set.
any ideas or work arounds? it would really help, i cant think of anything else.
thnx in advance