title: Advise on creating relationship in mysql with phpmyadmin
body: <p>I was wondering if anyone could help me with this as I am novice and very confused</p>
  
  <p>I want to able to assign customer to user (1:M relationship) but I cant figure how to do this in mysql. What I would like to do is in the customer table add the multiple id's of the user and then create a table where you can assign a new customer to a certain user or search how many customer a particular user has etc...</p>
  
  <p>I have been looking at creating relationship but I keep getting error in phpmyadmin</p>
  
  <p>Can anyone advise how to do this properly in the db please</p>
  
  <p>Thanks for all your help</p>