Looking-up certain records only

Hello everyone,

I have a very easy solution created to fill out forms more
efficiently: 2 tables (A and B)
some of the fields in Table B are "lookup fields" from Table A, and
this works just fine most of the times.
However, sometime I would like to go to a specific record in Table B
from A avoiding to re-lookup ALL fields.
In other words, there are certain situations in which I would like to
lookup the current (i.e. the most recent) record
but not the previous ones (leaving those records as I modified them).
I tried to find just the record I am interested in (in Table A) and go
to Table B from there, but apparently this does not work.
I am sure there is a way to accomplish this, but I cannot find it,
might you kindly help ?

Thanks a lot in advance,

Diego

Diego B wrote:

> I have a very easy solution created to fill out forms more
> efficiently: 2 tables (A and B)
> some of the fields in Table B are "lookup fields" from Table A, and
> this works just fine most of the times.
> However, sometime I would like to go to a specific record in Table B
> from A avoiding to re-lookup ALL fields.
> In other words, there are certain situations in which I would like to
> lookup the current (i.e. the most recent) record
> but not the previous ones (leaving those records as I modified them).
> I tried to find just the record I am interested in (in Table A) and go
> to Table B from there, but apparently this does not work.

Isolate the record in table b and do a re-lookup.


--
http://clk.ch