Automatically update second field from a related list?

[mtm_s]

I have 20 different divisions (customers) with approximately 20 people (receivers) in each division.

From my Invoice (related to the customerfile through DivisioName) I

[Vaughan]

It's a bit complicated because you have a lot of one-tomany relationships here that need related files.

You have a "division" database. Because each division have many recceivers, you'll need a file "receivers" related to divisions to track them. Not hard to do BTW. Give each receiver a unique id number (a simple serial number is fine).

Create a pop-up list choose the receiver based on what division is selected, then use a lookup to bring the name information into the related record based on the id number selected.

A lookup is best here (rather than a related field) because the names will be entered into the record automatically, but won't automatically change when the receover's name changes in the master record. This is good because you'll want to know who the reciever was at the time of the records creation, not what it is now perhaps years later.

[This message has been edited by Vaughan (edited December 11, 2000).]

[mtm_s]

Thanks Vaughan,

I