fshrewsb:

I've never used DBIx::Class, but I'd bet that if you look in the test suite for it, you'll find an example of foreign key insertion. Most of the popular modules on CPAN are pretty well tested, and should have a test case for anything explicitly mentioned in the documentation.

(For some reason, I can't seem to find DBIx::Class on CPAN right now, it comes back with "No results", so I can't pinpoint the test for you. In fact, CPAN doesn't find "Spreadsheet::ParseExcel", "Spreadsheet", "DBI" or "Data::Dumper" right now. It's returning "No results" for all my search terms at the moment.)

...roboticus

When your only tool is a hammer, all problems look like your thumb.