One form to another

[tabbycat1234]

I have a complicated situation to me anyway. I would appreciate any input.



I have one form that gathers all the information (name, address, etc.) it also has a place to put an envelope number.

The envelope number I need to be able to pull in a lookup field or something on on another form that will automatically pull up the persons name that is associated with that envelope number. I will then enter information associated to the envelope.

This is for a church. In the main form the secretary is putting in the envelope number. In another password protected form the treasurer is keying in what the person gave to the church by using the envelope number.

I hope this makes sense and someone can help me.

Thanks

[June7]

Show the table relationships. Secretary-entered data goes into one table, treasurer-entered date goes into another table, right? Treasurer form RecordSource can be a join of these tables. Is there another table for names and address? Or is this info repeated in secretary's table if donor donates more than once?