I am creating an inventory management database.
I want to be able to assign a product to a bin location in our warehouse. One product can only be in one bin....so there is a 1 to 1 relationship.
I read that 1-1 should not be a separate table but rather a field on a layout.
I want to make sure only one product ever gets assigned to a particular bin.
Should I create a pick list on the product layout and have all of our bin locations listed....then the user will select the bin where that product lives from the value list? If so...how can I make the bins that are already assigned products be excluded from the value list?
Or should I go ahead and create a new table (warehouse) and create records for each bin and relate them to the product?
Thanks for the advice