AnsweredAssumed Answered

Pointing a lookup to an auto-enter calculation

Question asked by phyv on Dec 13, 2017
Latest reply on Dec 13, 2017 by phyv

Hi everyone,


Table A contains a date field named "DateField" who's value I want to copy into a field in a layout in context of Table C. Table B contains a field called "Datefield" ( note the lower case "f"). From my layout in context of Table C, in the Lookup Feld Dialog"  I can choose fields from Table B but not Table A. Should I do an auto-enter calc to transfer "DateField" from table A into "Datefield" in Table B, so I can Lookup the field from Table A in context of Table C. Note that Table B's "Datefield" isn't present in any layouts and seems not to serve much of a purpose in this database that I just inherited. Thanks to all for being such a great help.