3 Replies Latest reply on Jun 13, 2016 12:07 PM by NiceData

    Search in related table/field does not retrieve complete results

    NiceData

      Newbie question here...

       

      I have two tables, let's say A and B, that are joined by a field which contains unique numerical ID values (I have data validation on to prevent duplicate values). I've added fields from Table A to the main layout for Table B. When I attempt to search for records on Table B based on a criteria from a field from Table A, the results do not return all matching records for said criteria. For example, let's say I'm searching for all records on Table B that are related to records on Table A where Table A's Field = "giraffe". When I perform the search, I only get a partial list of records that match the field criteria "giraffe."

       

      I'm wondering what I did wrong in setting up the join relationship or layout creation such that I am getting these strange results. Or is my approach to joining tables and data completely flawed? I appreciate you help and let me know if I need to explain anything further.