Look-ups between two fields

[jwacton]

I'm very new to Filemaker, but fast in learning.

I've searched for how I may be able to do this, and would appreciate any advice or ideas how to:

Problem to solve:

I have two tables related (A & :

Table B has data that may change, field X

Table A, Field Y needs update to what Table B, field X is when each new record is created.

Table B, Field X may or may not change over time.

Table A, Field Y will over time have records added, and only should what Table B, Field X at the time of the record creation.

Another way to say it:

Table B, Field X starts as 1

In july, I created in Table A, four records

7/1, 7/2, 7/3 (and at the time records are created Table B, Field is 1.

On 7/5, Table B, Field X changes to 2

On 7/6, I create record 5, and want Table A, Field Y to be 2, without changing the 7/1, 7/2, 7/3 records.

[Tim W]

Hi JW;

I would use an autoenter calc in table a field x like

relatedtable::fieldx

 with the "do not replace existing" checked in the field definitions.



You could also use the calculation in the field definitions.

Case( isempty(Field Y);relatedtableB::Field X; Field Y)

ps, my syntax may not be exact(typing from memory)

Hope this Helps,

Tim