Can I populate one form with data from the database?

Can I prepopulate one form with data that has been previously entered?

I understand the 'lookup' field and to use it to connect one form to another. I'm wondering if I can create a script action that looks up data based on a user-provided selection from 'lookup'?
dono2081