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.