import from table and transfer relationship
Ok so... i've checked a lot of documentation but nothing seems to answer the specifics of my circumstances (either that or it's worded in a way that i'm not connecting) and i'm not sure how to resolve...
Forum Discussion
Ok, i've come up with this work around. Please let me know if there is a better way.
Basically i split the process in two, and i first import the parent record and then get the Record ID# from the newly created record manually and paste it into a "Parent ID" field on the source table which is a look up field on all children, so when i do the 2nd step import, it puts the parent ID into the "related parent" field.
I was hoping for a less manual process, if possible.
Basically i split the process in two, and i first import the parent record and then get the Record ID# from the newly created record manually and paste it into a "Parent ID" field on the source table which is a look up field on all children, so when i do the 2nd step import, it puts the parent ID into the "related parent" field.
I was hoping for a less manual process, if possible.
- This may have been the most understandable solution I've found (and least time consuming). Thanks for sharing. If you found a better solution, I would LOVE to hear it. :)
