I'm new to working with XML data. When I try to import the XML file created by DVDProfiler into MS Access XP it creates separate tables for the diffent types of data (ie. DVD, AudioTrack, Format, Features, etc) which is great. But there is no primary key (such as the UPC or ID) in each of the tables to be able to link the tables (ie. linking which AudioTrack(s) go with with DVD), so except for the DVD table the rest is pretty much unusable. Any ideas or suggestions? |