How do I set up the key field so it will not incorrectly fill records?
I have a business solution that has different files which access the same table through a portal. The table is called "Doc. /Web viewer". I use it to bring up documents or web pages that I use for that file. in one file the Id key field was 22 but it brought in some records that another file was using which had the id key field of 0022.
How do I have different files access the doc web viewer with out bringing in files I didn't put there?
Right now, each file that has the portal in it has the id key set as a serial number and some of the id keys from the different files are matching. Can I place two letters in the auto enter "next value" and then have the number fill. So in my project layout the ID key might have "pr" then the next number value. Then in my task pricing table I might have "tp" then the number value. If I can do something like that the different id key would never match from one file to another.