Simple look up (but maybe not a look up)
I want to do this, but can't see how to do it. I have two tables in a database, and want whatever is entered in Field A of a record involving one table to appear in Field B of a record involving the other table. I've tried using the look up function, but this doesn't work. I'm sure there's a simple way to do it, but I'm too stupid to see it.