InfoPath Dev

Thanks for your responses guys. They are both pretty useful but I'm not sure which is the best solution. Patrick, as I'm understanding your suggestion I should put the data from my look-up tables in my main table (add a column for names in other words). The only problem as I see it with this is that this will not work based on how my form is ...

I have linked an Infopath form to an Access DB. In the DB there is one main table and several look-up tables. I did this because certain entries in my main table are formatted so I can periodically upload info to R3 and aren't user friendly (employee number for example). The look-up tables translate the number to a proper name which displays in ...