​I cannot for the life of me figure out how to normalize this table/form information. I have 10 fields for the TrimDate (the actual trim date entered by user). I need to see the information in this form design (similar to a spreadsheet).  But if I duplicate the Trimdate text box on the form, the information entered also duplicates. I understand why, but don't know how to avoid all these unbound fields. They will use this to input all the trims that are done then I will print out a report of what horse is due for a trim.
hope this makes sense

HorseT HorseID, HorseFarmName, etc...
TrimT  TrimID
​       HorseID   foreign key to HorseT
       TrimDate
TrimmerNameT TrimmerNameID            
             TrimmerName foreign key TrimmerNameT

form record source  TrimQ
HorseT ---> TrimT ---> TrimmerNameT

---

Reply from Alex Hedley:

You create a Form bound to TrimT
Add in all the Fields once,
Then set it to a CONTINUOUS Form
You can then add a new record for each Trim.
Have it open from the HorseF and set the HorseID = to Forms!HorseF!HorseID given your Horse Form called HorseF.
This will auto populate the Trim with the HorseID and then you can add as few/as many Trims as you need.