loading matrix items - ER map?

Apr 04, 2007 1 Replies

Hi, I need to convert an old Clarion database to RMS. I extracted most of the fields the customer needs but I am a loss how to map matrix items into RMS database using osql or import utility.



Seems like matrix item is defined in the itemclass table but I cannot find the link between the item table to the itemclass table.



I tried SOSchema document but it is not of great help. It would be very nice to have the ER map.



Any help is greatly appreciated.


ItemClassComponent.ItemClassID -> ItemClass.ID ItemClassComponent.ItemID -> Item.ID

RMS 2.0 changes the matrix table structures - haven't looked at them yet...

Glenn Adams Tiber Creek C> Hi, I need to convert an old Clarion database to RMS. I extracted

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required