Here again with a newbie basic question. I am sure I am making this much more complicated than it needs to be.
If I have multiple tables,…to keep it simple i’ll say 2 tables.
username <<<<<the username will be pulled from getUserName()
id_user INTEGER <<<<<<<<<<related to id_user in Users_Table
I want to insert a new record. The Other_data in the Other_Data table and the username in the Users_Table.
Likewise I want to SELECT the data to display as username and other data in a table.
I am thinking it will be something like:
INSERT INTO Other_Data_Table(id_user, Other_Data) VALUES (? , :data)
WHERE id_users = username FROM Users_Table id_user
Note that I will pass the user from getUserName() as a parameter but I need to get passed the relational database issue.
Other_Data will be additional tables that I will apply the same lessons to.
Thanks for the help,