Jump to content

Importing related record


El_Pablo
 Share

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.