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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.