Thanks Stephen. At least I know now so I can go ahead and create my inserts from data from the form. I just have to be careful to make sure they are done in an efficient order with the data in the right place.
The category one I have to be careful of as it isn't in a list control but a string box, separated by semicolons (Maybe it should be in a listbox) so I am not sure how to 'normalise' that yet. But I will. I'm sure I will have questions! -- View this message in context: http://sqlite.1065341.n5.nabble.com/Complex-insert-query-to-normalised-database-tp80590p80594.html Sent from the SQLite mailing list archive at Nabble.com.
