Hi Alex. I was just saying it's not so obvious to me when you should change a Table's 1)Text field (with potentially the same value(s) for multiple records) with corresponding Form Text Box control, to a 2)Number field, with corresponding HelperT, and make it a Combo Box on related Forms? That seems to be a bit of a grey area... Any ideas? Thanks!

---

Reply from Alex Hedley:

This is where Normalisation comes into play.
Do you have examples of where you would think otherwise?
The CustomerT has lots of information about a Customer and can be used in various other Tables, like OrderT etc.
It's easier to have an ID Field i.e. CustomerID as the Foreign Key than a Name which could change over time. The ID being a AutoNumber shouldn't change and can be stored in these other Tables and joined using a Query.