Thanks for the advice namliam. I've decided to go with the single table method and am working on creating queries to count records with specified field values instead.
Cheers!
Thanks for your reply namliam!
I know what you mean. Right now I'm looking at 30 tables this way... :p I'm not a fan myself, but not sure how to do it with one table - it may be possible, but I don't know how.
Right now box and rack are not variables in the actual tables. Basically, this...
Hi all,
What I am trying to do is simple (in theory), but as I'm very much new to Access and VBA I can't seem to get it right. I have a simple add form that will add an entry to one of two tables: Box 1-1, or Box 1-2. They have the exact same fields. In the add form, I want the user to specify...