0

Hi,

I need help with the following;

Table 1
---------
Col A
1
2
3
4
5

Table 2
---------
Col A ColB
1 AA
2 BB
3 CC
4 DD
5 EE

I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead of pulling back 'CC'. I need to pull back the data from a couple of rows down and get 'EE' returned.

Many thanks

Rottie

Edited by Rottieman: n/a

2
Contributors
4
Replies
6
Views
8 Years
Discussion Span
Last Post by Rottieman
0

What you are asking doesn't make sense, this is a relational database. If there is no relation in Table 1 with the Data you want in Table 2 then why would you try to access it using Table 1. What happens when someone deletes row 4 in Table2.

0

Hi cgyrob,

I agree with you, which is why I am having issue with it. Basically this is a external database and I cannot alter it in any way but the reference from one table relative to another is correct but the data 'EE' is shifted by two rows and I keep getting back 'CC'. Not sure if this can be adressed but if you don't ask...

Cheers

Rottie

0

Depending on how big the table is you could create a mapping table on your end to map to the correct rows in the external database.

0

Hi,

I think that is the only way around this issue, many thanks

Rottie

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.