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

 

Regards,

Jared

Outcomes