AnsweredAssumed Answered

searches on related table

Question asked by macmesser on Dec 28, 2013
Latest reply on Dec 29, 2013 by macmesser


searches on related table


     I have a database which contains two identical tables, Table A and Table B, which are related to one another by a unique valued key field called "Item Number." Before adding the relationship I had created some scripts which performed searches on several fields in Table A. After adding the relationship the searches work on layouts with fields from Table A only, with fields from Table A and Table B, and with  fields from Table B only. I conclude that once a relationship is added linking two tables, any search on one of the tables is really a search on the join of the tables. Correct or must this statement be qualified in some way? Thanks for any insights.