Link Transaction Table with Database Table


#1

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?