I'm very new to database programming so this question is pretty basic.... I have data that is currently organized as follows:
Each case has several fields that contain only one value. There are several fields that have a pipe-delimited string that represents a work history. Each work history item has its own fields like data, worker ID etc. So, as I convert my text files over to database format, I find myself wanting to have a table within a table. So, ideally the case table would have several singular fields and a field named "work history" that would contain a table that would have all of the work history in it. But, I haven't found a way to do this. If this is not possible, what would be the best way to organize data such as this in a database program. Thanks for the help. Mark _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
