I must be missing something here. Although I am a newbie I have learned a lot of the ins and outs of basic Infopath, but there is one issue that has me stumped. First the (long) setup:
I have a SQL server table of Company each of which has a Status. The choices for Status is a separate table of standard choices with a PK of idStatus. Company has ...