Register

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
    Location
    Bangor, Maine
    Posts
    12
    Member #
    35395
    I have three tables and need to update t1.medium.

    t1.pid & medium
    t2.pid & 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. T1.pid is unique for each t1 record. Then three records are 3 records added to t2 with t1.pid 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.

    ex:
    A painting is entered with mediums of oil, wax, mica

    t1.pid=1, t1.medium is blank
    t2.pid=1, t2.moid=1
    t2.pid=1, t2.moid=2
    t2.pid=1, 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...

  2.  


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 11:48 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com