![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
Diego B <messa... (AT) yahoo (DOT) it> 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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |