Having a strugle with proper relationship link for these two tables - see screenshot from simplified relationship chart -
Table A (Matrix_Master 2) has data of 6 different machines with product, and material combinations.
Table B (M_OmniBeam) builds records of operation time for each product/machine production.
I have primary key field in Table A for each instance with ID number populated.
Not sure what to do with the Foreign key field I put in Table B and how it populates with the correct ID to match Table A.
Not sure the correct relationship link.
Thank You for your help!