Can I look up descriptions or names of foreign key codes?
In other words, randomly inserting GUITAR when the INSTRUMENT is not a guitar because it's not linked to MUSICTYPE=1 (GUITAR) is NOT useful to me.
How do I handle this? The Foreign Key generator appears useless to me as it is only useful for populating the actual field named InternalMusicTypeId which has the integer foreign key.
Maybe I could run some UPDATES after the generation. But then I can't insert random stuff beside the lookup value.