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