Alpha Video Training
Results 1 to 3 of 3

Thread: Assign calculated field on form to table field

  1. #1
    Member
    Real Name
    Michael Klein
    Join Date
    Sep 2003
    Posts
    250

    Default Assign calculated field on form to table field

    Hi all.
    I've been wrestling with this since early this morning and feel really stupid as I'm sure I'm missing something really simple. I have a calculated field nDistributionMask on a form and a table field DistributionDays in the Offers table. How do I set the value of the table field to the value of the calculated field? I've tried the following in the OnSave event of the form, but the table field never changes:

    dbo_Offers.Distributiondays.value=topparent.nDistributionMask.value

    Offers is a SQL table. Please help.
    Thanks.
    Michael

  2. #2
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,168

    Default Re: Assign calculated field on form to table field

    if dbo_offers is the form name, then try:

    topparent:Distributiondays.value=topparent:nDistributionMask.value
    Last edited by Mike Wilson; 01-17-2010 at 01:13 PM.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

  3. #3
    Member
    Real Name
    Michael Klein
    Join Date
    Sep 2003
    Posts
    250

    Default Re: Assign calculated field on form to table field

    Mike,
    Thanks for the help. It worked perfectly! I knew it was something simple :).
    --Michael

Similar Threads

  1. setting calculated fields in form to a field in table
    By ashghai in forum Alpha Five Version 9 - Desktop Applications
    Replies: 8
    Last Post: 11-02-2009, 10:28 AM
  2. Assign Value to a field in a child table
    By johngtatp in forum Alpha Five Version 8
    Replies: 9
    Last Post: 02-20-2007, 01:18 PM
  3. Calculated field on form vs. table field?
    By Frank Calandro in forum Alpha Five Version 7
    Replies: 3
    Last Post: 02-06-2007, 10:01 PM
  4. How to assign a value from a dialog to a field in the table?
    By René Stout in forum Web Application Server v7
    Replies: 7
    Last Post: 03-15-2006, 04:21 PM
  5. Pass a calculated Form Field to Table Field
    By Robert Little in forum Alpha Five Version 7
    Replies: 1
    Last Post: 01-28-2006, 08:50 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
  •