I have a MS Access DB that monitors trailers in certain zones. There are only 50 spots in a zone. Now when someone is entering a trailer into a zone potentially they could enter to many trailers into say "Zone A" How can I restrict each zone to 50 trailer entries. Then if you try to put in 51 it will pop an error message.
I assume the table for the zone is a lookup table to another table that holds the number of trailers. I also assume that the table of trailers doesn't delete trailers that have fulfilled their job. So it has some kind of complete marker.
I'll explain this a bit better. What happens here is we have guards who let trailers into the building. When they enter the building the guard enters what kinda trailer and all this nice stuff into the Main Menu Form of the database. On top of all the specs of the trailer the guard in that same form must add a location the trailer will be stored Zone A, B, C, D, E. All of this information gets stored into a table. The Zone's are all in their own separate table. Each zone only has a certain amount of available spots. What is happening here is that the guards are entering more trailers into a given location than they are suppose to and I need to squash this problem.
Now it's a drop down box and they select it. So when they drop down the box and say A is full it will be grayed is what you're saying? I've never done this so ill have to try and figure it out but it could work.