4 Replies Latest reply on Jul 29, 2009 3:00 AM by g.w.powell

    Should I create a new file or a table in the same file?

    g.w.powell

      Title

      Should I create a new file or a table in the same file?

      Post

      I have created a simple database for my "Products". I now want to crate a related file/table to record "Sales" of these products.

       

      Should I create a new related "file" or a related "table" within the same file?

       

      Would I be correct in thinking that if I go the related table method that I won't be able to create access restrictions for the original "Products" file whilst allowing acces to the "Sales" area.