dbTalk Databases Forums  

Looking-up certain records only

comp.databases.filemaker comp.databases.filemaker


Discuss Looking-up certain records only in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Diego B
 
Posts: n/a

Default Looking-up certain records only - 08-29-2010 , 04:31 PM






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

Reply With Quote
  #2  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Looking-up certain records only - 08-30-2010 , 12:26 AM






Diego B <messadua (AT) yahoo (DOT) it> wrote:

Quote:
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

Reply With Quote
  #3  
Old   
Diego B
 
Posts: n/a

Default Re: Looking-up certain records only - 08-30-2010 , 09:44 AM



On Aug 30, 1:26*am, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:
Quote:
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.
In the facts, very simple and effective solution. Thanks a lot !

Diego

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.