i have been asked to create a database to record customer complaints and am unsure how to seperate the fields into tables and form the relationship.
There are not to many fields just ID number, Date, Department, Category, Short Description, Full description, customer details, action taken & response.
i have thought that maybe i should create two tables one to incluse Id date & department then all the rest in another and create the relationship between department & ID.
does anyone agree or disagree with this or offer any advise.
thx
CJB
There are not to many fields just ID number, Date, Department, Category, Short Description, Full description, customer details, action taken & response.
i have thought that maybe i should create two tables one to incluse Id date & department then all the rest in another and create the relationship between department & ID.
does anyone agree or disagree with this or offer any advise.
thx
CJB