0 Replies Latest reply on Oct 10, 2015 12:01 AM by knollar

    Help with showing records from two tables in a list layout

    knollar

      Hey guys,

      First of all, I am not too sure how much information I need here - so please ask if you need anything else.

       

      I am currently working on a database for a farming company, and they would like to have a layout where they can see all of the chemicals applied to specific patches, as well as the amount of fruit that has been picked from these patches.

       

      So, I have a Chemical Entry table, where the use of chemicals is recorded (they select a drop down list for the Patch the chemicals were used on), and a Packing Table, where they record the amount of fruit packed (and select a patch from the same Patch table as in the chemical layout).

       

      Obviously, this causes errors when trying to make the list which shows records from both tables - as they both use the same PatchID.

       

       

      Please help in anyway you can, and let me know if you would like some screenshots

       

      Regards,

      Jared