If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 1 of 1
  1. #1
    Junior Member
    Join Date
    Feb 2013
    Bangor, Maine
    Member #
    I have three tables and need to update t1.medium. & medium & moid
    t3.moid & medium_option

    Someone else designed this relational system because I am not that familiar with the process. Basically, a record is inserted into t1. The input screen allows multiple intries for a field called medium (lets say 3 for this). Because there are multiple entries allowed, t1.medium is blank. is unique for each t1 record. Then three records are 3 records added to t2 with and each is assigned a unique t2.moid (I don't know why). Then (and I still don't know why) three records are added to t3 with t2.moid & medium_option which are the actual selected mediums on the input screen.

    A painting is entered with mediums of oil, wax, mica, t1.medium is blank, t2.moid=1, t2.moid=2, t2.moid=3
    t3.moid=1, t3.medium_option=oil
    t3.moid=2, t3.medium_option=wax
    t3.moid=3, t3.medium_option=mica

    I NEED to update t1.medium to equal "oil,wax,mica"
    Any ideas, PLEASE & THANKS...


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
All times are GMT -6. The time now is 07:08 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: