title: Oracle Apex: How do I tell Apex to use the value from a column of another table?
body: <p>FIRST, we are not using code. We are using the Apex GUI to set up the database. I need the column of one table to take the value from the column of another table. If it's a Trigger that I have to create, then it will probably require the code.</p>
  
  <p>For example, I have a table "customer" in which there is indicated under the "member" column a yes or no.</p>
  
  <p>I want the table "order" that also has a "member" column automatically take the value from the table "customer"'s "member" column whenever a new row of data is input for the table "order."</p>
  
  <p>Do I do that under "constraints," because when I try to create a foreign key of the member column, it keeps giving me an error. </p>
  
  <p>Do I do that under "Triggers?"</p>
  
  <p>Please understand, I do not understand the code very well. When someone says something like</p>
  
  <p>COMMAND table1 s
  (
    Whatever comands
  );</p>
  
  <p>I have no idea what the "s" is for. And I'm pretty sure there's a lot of other stuff I don't quite understand either. I have been introduced to MySQL, but it apparently has some differences to Apex Oracle.</p>
  
  <p>Thank you.</p>