If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Another Query Question
Hi all
With the help of Ken Sheridan, I feel in touching distance of a solution to my current application issues. I have a union query which returns results on links made between accounts. Each entry represents a defined link between 2 accounts - there is a remarks column (not shown) associated to the link describing the reason behind it. There are 2 fields in the union query: link-id and ac-id. So the output of the union query looks like: link-id ac-id 1 1647 2 1639 3 1681 4 1677 5 1681 1 1677 2 97 3 1661 4 1618 5 1682 A further query is run on the union query with a user input ac-id - this lists link-id 1 & 4 for ac-id value 1677. I now need to requery the union query to find the "other side" and the linked accounts i.e. for 1 & 4 the linked accounts associated with 1677 are 1647 and 1618 respectively. This is where I am stuck! How do I re-query the union query with results from yet another query? TIA Phil |
Thread Tools | |
Display Modes | |
|
|