Hi
I would like some help if possible with the following situation.
I have database which I would, at some point like to allow customers,
suppliers and our own staff access to the database. At present I have
tables for staff members of all three categories, however I feel that
there must be a way to just have users in one table, with someway of
identifying which category the user falls into. I understand how to
include a category field in each user record, but it then gets untidy
when I include which company customers and suppliers work for, in as
much as each user record would have a which customer company field AND
which supplier field in every record.
Am I being to rigid in my approach to reducing tables etc or is there
a standard approach to this type of situation?
Thanks in advance for any help anyone give me
Steve