Dear Wilie Loh:
Your question does not supply sufficient details to permit me to understand
the basis for what those potential numbers should be.
One might presume uniqueness is a factor. However, it is not clear why 2899
would be a potential number for the row 2499 but not for the row 3678. Or
is it? How are potential numbers restricted or otherwise based on the value
in that "column in another table."
I hope you can understand why there is little comprehension here of what you
need, and that you can explain it.
Tom Ellison
> How to add potential nos to list in table but append to column in another
> table?
[quoted text clipped - 22 lines]
> 4668
> 4899
Duane Hookom - 19 Mar 2006 22:39 GMT
Wilie Loh has the same question in Tek-Tips
http://www.tek-tips.com/viewthread.cfm?qid=1206363 with the same level of
understanding from a couple of us trying to help.

Signature
Duane Hookom
MS Access MVP
--
> Dear Wilie Loh:
>
[quoted text clipped - 37 lines]
>> 4668
>> 4899
Tom Ellison - 19 Mar 2006 22:45 GMT
Dear Duane:
I expect perhaps you mean the same level of non-understanding. As in, total
non-understanding. I have no idea what he wants. I just hope he can
express himself as to what he needs so someone can help.
To Wilie Loh: in what language would you be most comfortable? We may be
able to direct you somewhere that it is easier for you to express yourself.
Tom Ellison
> Wilie Loh has the same question in Tek-Tips
> http://www.tek-tips.com/viewthread.cfm?qid=1206363 with the same level of
[quoted text clipped - 41 lines]
>>> 4668
>>> 4899
Duane Hookom - 19 Mar 2006 22:54 GMT
The other responder in the tek-tips thread is fairly good at guessing
underlying needs and it seems we are all equally confused.

Signature
Duane Hookom
MS Access MVP
--
> Dear Duane:
>
[quoted text clipped - 53 lines]
>>>> 4668
>>>> 4899