November 29, 20178 yr I have a set of tables that pull information into a separate table (Table A) , to populate it and prevent user data entry that is incorrect. What I'm trying to do with field A (Table A) is filter records (from Table B ) through field B (also Table A) and then choose from the remaining records by a range of two fields in Table B of a minimum number and a maximum number. If field C (the number field in Table A) is equal to or between the min and max, then a field from the same record in Table B fills in field A, Table A. Edited November 29, 20178 yr by Ponderosa
Create an account or sign in to comment