Fields not appearing in all reords
I'm not good at explaining in a few words but will try and hopefully screenshot will help
I have two tables Profile & History. History is a many to one Profile relationship
I have a date field 'Custody' & 'Probation' though there are multiple records in 'History' only one occurence of the fields 'Custody' & 'Probation' are being displayed.
Notice too how there is no blank boxes for these fields too. I had them all showing at one time but in attempt to sort the 'Custody' from newest to oldest something I must have unknowingly changed something.