str handling

the problem is that an afsc is made up of 4 elements. prefix, afsc, skill, and suffix. i need a box that stores the full afsc, but i can't use a cbo box with all possibilities (there are just too many)

so the only reasonable approach , as far as i can see, is to store a calculated result... i would have another cbo box just equal the values i need but i need to store it in the table for query/report reasons. although i may be able to think a way around that, hrm... i think ill have to crack at this for awhile.
 
The way "around it" is to not store it but calc it when ever you need it, on a form, query or report...
You might/should even make a function for it...

Regards
 

Users who are viewing this thread

Back
Top Bottom