Hello everyone,
Sorry for the verbose title, I wasn't quite sure how to word it. Basically I am designing a (reasonably) simple InfoPath form to send via email then import to access from the saved XML. I have two sections; person details, then systems access. I can get these two sections imported as two tables fine, but in the second table, systems access (basically just a list of the systems a user will need to access, one field, many values) there is nothing to link this to the person details. I tried adding the name of the person by adding a duplicated read only field from the form to the systems access section, but when I import it, its blank. I did try and search the forums but I couldn't quite find what I was looking for.
Background: Access 2007, InfoPath 2007. I've used Access for over 10 years now, but new to InfoPath. I've designed a couple of standalone InfoPath forms, and know the very basics of XML but that's it. Any pointers would be gratefully received. Thanks.