Table Setup

[Neo]

Hi all

I am trying to set up a simple db which records errors that occur on a systems.

These are the fields required

Error Title
Date occured

Fix 1
Fix 2
Comments

I am not sure how to design the tables so that each title is unique and references a the fixes

any help would be great thanks

 

[Mile-O]

You haven't given much to go on.

Thought it might be good to add the user who created/reported the error.

tblErrors

ErrorID
ErrorDescription


tblErrorLogs

LogID
ErrorID
DateOfError
FixID
User
Comments


tblFixes
FixID
FixDescription