Looking for Microsoft Access and InfoPath experts.

For #2 you would just created a calculated field.

You don't need to manaully re-enter something that's made up of data already present in the row.

http://allenbrowne.com/casu-14.html

That's the thing I'm not re-entering it. The Ref # is supposed to automatically generate using data from other fields and it does that. The problem though is that it doesn't update the data Table from the data Form, so when I try to call up the data and view the Ref # in InfoPath it doesn't pick it up.