Search results

  1. F

    Data from form to insert query

    Yeah of course, the previous record would be something like this (I'm relatively new to this so not certain how to format this style of stuff: OutreachType: Email OutreachDate: 05/09/2019 FollowUpDate: 13/09/2019 FollowUpType: Email Marketing CustomerID: 123 Notes: Follow up with monthly...
  2. F

    Data from form to insert query

    Thanks for getting back to me. Not quite, the two operations I need to happen are: 1) The boolean is updated to true to reflect the fact I have taken the action (this I can do) 2) There is a new record created for each individual I emailed, the data for the values OutreachType, OutreachDate...
  3. F

    Data from form to insert query

    Hi guys, I suspect I am going to need to use some SQL here and I am slightly lost. Would appreciate some help. I have created a DB which tracks my daily sales activity (e.g. phone calls, emails). I have tables for: tCustomer tCompany tOutreach It's all pretty simple stuff, within tOutreach I...
  4. F

    Table help for complete noob

    Good morning, I'm pretty sure this is a really simply question, and feel free to scoff and laugh at my expense. However I've been stuck with this problem for a few days now and just need someone to point me in the right direction! I have created my first database teaching everything to...
Top Bottom