Creating work assignment app

Creating work assignment app

I am working on an App to track work orders completed by an empoyee.  I would like to keep my data in four different tables.  Is this the best way to go about doing this type of  app?  I am planning on using on using the Johnsmith, PropertyName, UnitNumber field as look up fileds.  Please advice and any guidance would be greatly appreciated.

My goal is to be able to track work progress and report on properties adn units that have had maintanence performed and which employee performed the work. 


………Empoyee……Propertyinfo……....UnitInfo…………….TaskAssingedTo......
FirstName              PropertyName        UnitNumber            StartDate     
LastNmae               Location                StreetName            John Smith
                                                                                     PopetyName 
                                                                                      UnitNumber 

Thank you very much