I have a form which is primarily pulled from Table1. Table1.fieldA is an integer representing a project phase. In the current Access display the form displays not the integer, but a String stored in Table2 that holds integer/String pairs representing all the phases.
I'm trying to figure out the best way to reproduce this in my .NET formview. I could write code that would parse the int and display text, then reverse the process at save or insert, however then the code has to be updated if a new phase is added to the database.
Clearly it would be better to draw the String values from Table2 while preserving the binding to Table1 but I haven't figured out how.
Is this possible? Is there a best practice? I'm working in .NET 2.0, btw, so compatible answers appreciated (though if you're not sure, I can do that research.)