Re: definning table key

adel@q8petroleum.com.kw (Adel Al-jouhar) wrote: >I 've created a table with 8 columns, 6 of them to define >one record (key), this table updated once a year >the second table contains 7 columns (the same above 6 columns + 1) >now this table is updated weekly >can I do better than that, regarding key structure....? As a general rule, one should never have two tables with the same key. Unfortunately, there is insufficient detail here to determine exactly what your requirements are. Gary