Check if Wooden Box exist for an Item

[Pippo]

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

[CJ_London]

bit confused - you want data from table2, but your code references a form

Also your formula will bring back all boxes over the size, not just one

Suggest provide some example data and the required result

[Pippo]

Yes I have a Form with data from Table1 , then I'd like import some data from Table2

[davegri]

Pippo, way too confusing. You talk about 2 forms and 2 tables with not much to distinguish what each is all about.
Some images would help, but best of all post the DB.

[CJ_London]

I agree - I asked for some example data

[orange]

Pippo,

Your requirement is not clear. Please step back and describe what you are dealing with in simple, plain English. You are telling us how you have set up something without any context.
If you were to hire someone to "build a solution", that person would want to know more about what you are trying to do.
More info and example(s) required.
Good luck with your project.

If English is not your native language, then write your description in your native language, then using Google translate convert your description to English and post.

[TommyK]

It would appear that your boxes are actually tubes with a diameter and length. Diameter would indicate that it is round, much like a hat box or shipping tube. You also seem to be struggling with translating your request into English. You also reference a 'wooden' box in your title. I've never seen a tubular, wooden box. Square boxes have a length, width and height. Pre-made, ready to use boxes of this sort are usually made of corrugated cardboard, or paper, but could be made of wood or other material.

Having said that, assuming you have a cylinder or round bar shaped item, if you know the diameter and length of your item, you should be able to query your box inventory for a box which has a diameter >= to the item's diameter AND a length which is >= to your item's length. This should be very simple.

If, however, you actually are looking for a box with a bottom, four sides, and a top, the sides of which are rectangular in shape, you have a challenge. If, you do a comparative search on a length (l) field, width (w) field, and height (h) field for box values which are >= to the comparable dimensions on your item, then if your item, in your database is 10 x 8 x 6, and you have a box which is 8 x 6 x 10, your search will come up empty, as all three of your individual dimensions will not match up. Even though an astute shipping department can see that your part will fit into the box, the computer cannot deduce this. This is an interesting problem.

If your firm instituted a policy that all boxes would be sized from the dimensions l, w, h, from longest to shortest, and do the same for the item dimensions in both tables, this would simplify the search.