I have table one with columns ID (Primary Field, Auto Number), Date, Product, Opening Value, Closing Value.
Table two has ID (Primary Field, Auto Number), Linked ID (Linked to Table one, shows ID of Table one), Date (Lookup Field), Product (Lookup Fi...