IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

bridge table/many-to-many relationship/table with more than one foreign keys Options · View
soup
Posted: Friday, December 7, 2018 12:15:22 PM
Rank: Newbie

Joined: 12/7/2018
Posts: 1
Hi,

I am trying to map data from xml to postgres database. The database has a few link tables that resolve many-to-many relationship.

As an example, I use person and address tables with many-to-many relationship and then there is person_address bridge table with only two columns: personId(FK) and addressId(FK). Both personId and addressId are auto-generated by the database (or I can use max()+1 to fill it from mapforce).

If there was only one foreign key in the table then I would have resolved it by defining relationships in mapforce but I am a bit lost here in this case. I want to know how can I populate multiple foreign keys in a table coming from more than one tables?

Also all the relationships between the objects are defined in the xsd and once the data gets into the database I have no relationship track anymore.

Thanks in advance.
K101
Posted: Wednesday, January 2, 2019 9:00:14 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
If the relationships for all these keys are not defined in the database and defining them locally in MapForce doesn't help, then it would probably be best to supply some example files with a portable database such as SQLite or Access. I would also suggest sending this directly to Altova Support.
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.