4 Replies Latest reply: Jun 23, 2017 2:53 PM by Ruytter Mendonça RSS

    Sugestion: Avoid Synthetic keys

    Ruytter Mendonça

      Hi, everyone.

       

      I'm having problems whit tables that relates with other tables.

      Like the vendors table (lets call it V), it relates with the sales (S) and customer (C) table, whitch also relates with each other (S x C).

      This is generating synthetic keys, because sales relates with vendors, customers relates with vendors, and sales relates with customers.

      What can I do to avoid this problem?

       

      Thanks!