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.
For example, I have a table "customer" in which there is indicated under the "member" column a yes or no.
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."
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.
Do I do that under "Triggers?"
Please understand, I do not understand the code very well. When someone says something like
COMMAND table1 s ( Whatever comands );
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.
Thank you.