Jump to content

BaySunshine

Members
  • Content count

    1
  • Joined

  • Last visited

  1. Hello James, It is not possible for a trigger to insert a new record in customer billing table since the tables are related by many to one, meaning many records with same customer name in the order table and only record to be created of that name in the billing table. By changing the design of the table, this can be achieved. Please see below screenshots of the table design and the trigger that I could implement by making this change. Hope this helps.
×