Greetings! I'm new to access, so please bear with me.
I'm building a database to keep track of garment inventory/assignments for my choir program at school. I want to use a table with the key being a generated string with the garment type and number embedded (ie Pants number 24 would have key P24, while in the same table Coat 7 would be C7). I'm trying to build the form to populate the garment table. The first thing the form asks for is for the garment type (combo box with all the appropriate options). As soon as that's updated, I need to look at the table and see what the highest number is for that garment type and assign this new garment 1 higher (ex. I tell it I'm adding a pair of pants. The AfterUpdate sub looks at the table and sees the highest key with a lead character of "P" is 16, so it assigns this garment I'm adding key P17). After that, I know how to get the measurements imported for the new garment. Any ideas? Thanks for your help!
Tidak ada komentar:
Posting Komentar