I recently posted this question on StackOverflow:
http://stackoverflow.com/questions/7314 ... o-2-tables

In a nutshell, I'm trying to map 1 object to 2 tables. During a save, most of the time only 1 table should be updated and reference an existing record in the other table. But sometimes both tables will need updated. It's a bit of a complex scenario, but I don't feel like it's that uncommon of a situation.

How would we accomplish properly saving this object to the appropriate tables? I primarily need help with the mapping. Also, I am using Fluent NHibernate for the mapping, but if we need to we can use config files.

Please take a moment to read the question on StackOverflow. You can answer either here or there. Thank you for your time and help!