AnsweredAssumed Answered

Help with showing records from two tables in a list layout

Question asked by knollar on Oct 10, 2015

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