How to setup 1 to N vs. 1 to 1, for each item inside of a Box?

[Casey_Whitcher]

Hey all, suppose in my database I’m putting items in boxes.

Each item can only be in one box, but each box can hold many items.

I would think I’d need to create a column in both tables, (boxes and items) for items and boxes respectively, with the box column in items being 1:1, and the item column in Boxes as 1:N.

Is this correct, or do I even need an items column inside of the boxes table? Or, do I need the boxes column inside of items table?

As it is, I can select multiple items inside my individual boxes, but then in items I can choose a different box for the same item?

[Alexander_Pavelko]

Hello @Casey_Whitcher!

@Casey_Whitcher

I would think I’d need to create a column in both tables, (boxes and items) for items and boxes respectively, with the box column in items being 1:1, and the item column in Boxes as 1:N.

Yes, that’s right, if you create such a structure, you can select multiple items inside individual boxes and then in items you can choose a different box for the same item.

Regards,
Alexander