what am i doing wrong with look up?
So I'm trying to get a look up to work.
I have a database of customers, that give in regular payments. Each customers also has a TOH number.
We create daily check receipts in excel however i wanted to create a better database for tracking payments and so on.
So on a daily check receipt i need the TOH number to show up, i assume i can use a lookup, but it isn't working.
I have attached a link to a dumbed down test database to find out how to get this lookup to work right.
Hope someone can help.