Alpha Video Training
Results 1 to 2 of 2

Thread: Table to Table update

  1. #1
    Member
    Real Name
    Kerry Bugger
    Join Date
    Dec 2008
    Posts
    36

    Default Table to Table update

    Could some tell me how to update a field in one table from a field in another table. A simple add or subtract.

    Thanks
    Last edited by Kerry Bugger; 01-12-2009 at 06:43 PM.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Table to Table update

    If memory serves you can create operations, one type of which is an update?

    Create a set with the table you want updated as the parent linking on some common field to the other table. Define the update operation for this set.

    You should also be able to define a posting operation from table to table which might meet your needs (no set required).

Similar Threads

  1. Update table
    By den1s in forum Web Application Server v7
    Replies: 17
    Last Post: 09-29-2006, 11:24 AM
  2. table update()
    By andymeer@yahoo.co.uk in forum Alpha Five Version 6
    Replies: 2
    Last Post: 09-16-2005, 10:18 AM
  3. How to update table
    By RupertP in forum Alpha Five Version 5
    Replies: 6
    Last Post: 11-21-2002, 04:55 AM
  4. Scrolling Screen query table and update table
    By mpierce in forum Alpha Five Version 4
    Replies: 2
    Last Post: 09-21-2000, 09:38 AM
  5. How do I update a table
    By Mike Reed in forum Alpha Five Version 4
    Replies: 5
    Last Post: 07-21-2000, 02:03 PM

Bookmarks

Posting Permissions

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