Compare Tables in Background

Results 1 to 2 of 2

Thread: Compare Tables in Background

  1. #1
    Join Date
    Dec 1969

    Default Compare Tables in Background

    I have three tables. The first table(tbl_Code) has one field called Code(no primary key). The second table(tbl_Inventory) is an inventory table(with the code field and then some others in it, including an Inventory Field). The third table(tbl_Compare) is the same table as the second minus the inventory field. The tbl_Code table is being populated from a web front end. This is what I want to do. I want to run an OnUpdate statement comparing the tables to eachother. How can I do this in Access(maybe this is a stupid question but I just can&#039;t put my finger on it). Basically I can&#039;t figure out how to fire off the OnUpdate Statement. <BR><BR>Psuedocode<BR>tbl_code onUpdate<BR>If tbl_code.code = tbl_inventory.code <BR>then <BR>tbl_inventory.inventory +1<BR>else <BR>add <BR>tbl_code.code to tbl_inventory.code<BR><BR>then <BR>if tbl_inventory.code = tbl_compare.code <BR>take that record from tbl_compare.code<BR>and add it to the tbl_inventory.code where .code is equal to each other. <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Compare Tables in Background

    you&#039;re talking about a trigger, essentially, right?<BR><BR>access doesn&#039;t support them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts