In Table1 I have general information and cost about each singular Item, so I wanna import some information from Table2 where I have Box information and cost
I have table 1 with ItemNumber , Diameter and Lengh , BoxType1, BoxCost1
Table 2 BoxDiameter and BoxLengh, BoxType, BoxCost
How can I associated to find if exist a box for some Items ?
If Forms!Box!BoxLengh * 5 / 100 >= me.Diameter Then
If Forms!Box!BoxLengh >= Me.Lengh Then
Me.BoxType1 = Forms!Box!BoxType
Me.BoxCost1 = Forms!Scatole!BoxCost
End If
End If