We have one database that we scan transaction codes into. From there we have several databases with products. What we need is to have the transaction database search the other databases when we scan a code into it and flag the item when it finds i...

I am looking to create an ID for our records that combine the first Three letters of one column (TEM for example) with a generated date and time code that can be inserted into a barcode (02222018182947 - February 22nd, 2018 6:29:47pm). A completed co...

I have a formula that produces a product ID in one table, I would like link that column to a single text column in another table. Can I create a column that is both a formula and is linked to another table?

Has anyone had any success with linking a transaction table with a separate database? The goal is with each scan of inventory to automatically remove indicate sold and date sold. Any recommendations?

All of the data in one of my tables disappeared. I am unsure of why it is missing. I followed the directions to restore a snapshot and that brought my data back. The one issue I now have is a huge deal breaking problem. The product id field in the re...