loading matrix items - ER map?

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.

Reply to
John Kim
Loading thread data ...

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

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.