Quick Question

Discussion created by user26927 on May 9, 2016
Latest reply on May 10, 2016 by user26927

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 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 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