Importing related record

[El_Pablo]

Hi,

I'm having trouble importing related record. Is there a way to import the record and it's related records in one step?

Here's a simple example:

A tables named "Houses" can have one or more pictures which are stored in the "housePhotos" table.

It is easy to export the house and its photos, but how do I import the house and photos in one step? If it not possible, what is the simpliest way since the person who will import the data is not a computer freak?

Thank you

[Ender]

Each table needs it's own Import. This can be scripted by first finding the parent records in the source table, then using Go to Related Records [ Show only related; Matching all ] and then running the import script in the destination file:

Go to Layout [ Houses ]

Import Records [ Table: House::House]

Go to Layout [ HousePhotos ]

Import Records [ Table: House::HousePhotos ]