Not sure if I have described this correctly.

I have a form which has a drop down linked to another forms data. However when this has been selected we need two of the fields from the dropped down data to be displayed as references. So they don't need to be saved in this form as this would mess up the integrity of the data.

I thought this would have to be a static form that is effectively a duplicate of the actual one but with a couple of additional fields that I can read the bits of reference info into. The submit would save the rest of the data.

I was then going to attach this static form to the report of this data but am not sure how to do this for both new and edited entries.

Sounds a bit long winded so just wondered if there was an easy way to create a read only field that isn't saved to the actual record im working on?

Could this be done via a formula field?

Hope all that makes sense?

Thanks