Hi Clay,
Thank you for the guidance on this.
I recreated the form as you suggested. I am having a small issue with it though.
First, I am using Infopath 2003 SP2 if that is pertinent.
Let's say this is the table I am using in my Access database
PN MFG
A11 ...