I have Parent objects that contain the object geometry. I have migrated them into the database. I have Child objects that in need to be migrated as well. The Child objects do not have geometry (nor do they need geometry) . I just need to migrate the Child object to the respective Child table in the SW database and link to the Parent object via the Parent Facility ID. Any insight is greatly appreciated.
Question
I am migrating data into Smallworld from spreadsheets. Can I get some insight on linking Child object (without geometry) to the Parent (that contains the geometry) ?
@andrewortiz whether you can achieve success might depend on the type of join you have in your Smallworld data model. You might also have to make the foreign key visible in the child Smallworld table . The article on working with join fields in our Smallworld training might give you more insights. You probably have to read back your parent table to recover the primary key as shown in that article.