Auto partially populate form

[RLT]

I have a someone that has a form (created from a table) and as they started
entering data, they realized they have alot of the same info.

How can I do it so that if they press the "P" certain fields will auto
populate but if they hit "O" another template could popluate other fields.

 

[John W. Vinson]

I have a someone that has a form (created from a table) and as they started
entering data, they realized they have alot of the same info.

How can I do it so that if they press the "P" certain fields will auto
populate but if they hit "O" another template could popluate other fields.

If you're storing the same data redundantly in multiple records, in multiple
fields... your table structure may be incorrect. Might you in fact have
several different kinds of entities, related one to many?

What's the structure of the underlying table? What real-life things, persons
or events does it represent?