InfoPath Dev

Hi Sorry if this has been asked before. I have a InfoPath form connected to an Access database, what I would like is for to be able to manually enter data in field A and the other fields in that group prepopulate based on the value of field A. It sounds as if it should be pretty straight forward but...