Do you have proper IDs in your data? Access won't just magically create relationships if you don't have primary and foreign keys.

Let me see a sample of the data - both tables. Just a few records.

What ever I try to copy here it looks like a mess. I will send you a very small database, just the imported records and the xml file.

Its in an e-mail called "Document related to the "Import XML" question in access forum" from Jan Holm to [email protected]

/ Regards Jan Holm

There are a couple of sites where you can post Code Snippets:

https://gist.github.com/

https://pastebin.com/

Jan, I received your email. I'll take a look at it as soon as I get some time.

OK, sorry for the delay, Jan. I took a few minutes and looked over the XML files you sent me. Basically, the data is all there, but it wasn't EXPORTED to be relational. For example, if you look at the RECIPE table, it's got a field called NAME (which is a big no-no in Access) and you've got Burton Ale, Dry Stout, Porter, and Wit. No RecipeID in the table. So now you look at another table like YEAST which should (I believe) be a related sub-table to RECIPE, and it's got the NAME field again with the same 4 listed names. Again, no IDs. So whomever built the original database didn't know about relationships. The only way to solve this is to import the data (which imports easily into Access) and then add primary and foreign key fields where needed (a RecipeID in both the RECIPE and YEAST tables) and then use update queries to change the names in the YEAST tables to IDs. I cover how to do this in Access Expert 14.

Ok, thanks! Will do that.