Should I create a new file or a table in the same file?
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.