Auto population of one field based on entry of second field.

[GinaWhipp]

Autopopulation...
I'm not sure what you mean by *several ways*. Which other ways?

Searches...
As you would be using a query the NumberRank would available so still no need to store in the Main Table.

Hmm, maybe the better question would be... What are you trying to learn?

 

[zoobeeda]

please see attachments

 

[GinaWhipp]

Please post here what you are expecting... Tis a little unfair to expect me to read thru 9 pages of documentation and figure it out OR you can start a new thread with your new/updated expectations to get more eyes on your issue. You might also want to post what you have tried and what happened.