I'm working on a warehouse database project. I'm attaching a sample database with 2 tables. The locations table has all the warehouse locations listed. A01, A02, B1, Etc.
I have a lookup function on the Table1 that gets the locations from the locations table. It is setup for multiple values. I need this because some products will have to be stored in multiple locations. That part was easy.
What I would like to do now and I think the data macros would be the best option is that when a location is selected in table 1 it sets the occupied field in the locations table to true or it hides the location so it can't be selected again.