Combining two tables to one

[Jerseynjphillypa]

I have two tables called Item and Type.

I would like one table which contains all the Item with all the Type.

For example when the tables are combined, the one table you should see

Item	Type
A	Order
A	Shipment
A	Stock
A	Available
A	Projected

This should repeat for the next item will all the type next to the same item

[pbaldy]

Haven't looked at the sample, but it sounds like you want a Cartesian product. Add both tables to a query with no join between them and see if that produces the desired result.

[Jerseynjphillypa]

Thanks for your help.

[pbaldy]

Happy to help.