I'm just learning this database stuff and so I am a bit confused and was hoping someone could push me in the right direction. I have managed to create users in the wp_tables I have created in my database.

Here are my specific questions.

1. What I am wondering is how do I link the hm_tables with data from the wp_tables. Because if I don't how will we know which hm_account is linked to which wp_user? Is this dumb? I was thinking I might need to add in the user_ID or something from wp_users but I don't know how to do that?

2. Also, I have become familiar with using WPDB commands, but when playing around with the hm_tables can I use $wpdb or do I need to use straight SQL commands.

Can you please give explicit instructions or examples as I get very lost at this early stage. I have read around but can't seem to find something that explains this at a level I can understand (which at this stage is quite low).

I'm just learning this database stuff and so I am a bit confused and was hoping someone could push me in the right direction. I have managed to create users in the wp_tables I have created in my database.

Here are my specific questions.

1. What I am wondering is how do I link the hm_tables with data from the wp_tables. Wouldn't I need to insert a foreign key (i.e email address from wp_users) into the hm_tables. Because, otherwise I won't know which hm_account is linked to which wp_user? Is this dumb? And if so, HOW?

2. Also, I have become familiar with using WPDB commands, but when playing around with the hm_tables can I use $wpdb or do I need to use straight SQL commands.

Can you please give explicit instructions or examples as I get very lost at this early stage. I have read around but can't seem to find something that explains this at a level I can understand (which at this stage is quite low).