Primary Key not working?
I have built a small standalone database with a few tables. Everything in it is working fine as I want it to. I have literally copied the tables from this database and pasted them into another database (where I actually want it to be) and configured the tables, relationships, calculations etc to be the same.
In this new database for some reason the primary key is not working properly. If I enter an ID number into the Asset ID field (which is the primary key), the merge field of the primery key does not do anything. It remains as "<<__pkAssetID>>, instead of actually displaying the Asset ID number. I have gone over everything I can think of to make it work but I haven't found the solution. Anyone have any ideas why this is happening?