You’re offline. This is a read only version of the page.
Announcements
8
Hello,
I developed new form with my 2 datasources that are also datasources on the form from which my new form is called.
So, main form has menu item that calls new form with the same datasources.
One datasource is parent and one is child.
When I save the data on my new form its ok and I dont get an error but when I click refresh (only the data refresh) I am getting Getting the parent node failed error and I am unable to debug it.
Any help?
Thanks in advance
Lets say I have a lease object which is the parent:
And it has areas as you can see (child).
When I click on Merge I want to select other lease objects that I want to merge from (their areas):
When I enter that page I click on New, select some of the existing lease objects (it actually doesnt create new record, I made it so it just populates the field needed to relate these two lease objects)
When I click on New on Area tab it should show me lookup for lobj2 but when it creates record, it should relate to the calling lease object (lobj1), so I am basically creating a child (area) for the calling parent.
So these datasources on my form that I enter by clicking on Merge are not joined.
What do you mean by the result? It sounds like you want to create two table records, but each of them will have a different table schema. It's also not clear to me how it's related to the previous discussion. Please elaborate.
On the main form I have those mentioned datasources.
I needed new form that I will use to merge data from other records.
Example:
1. record: Record 1 (parent) has Child record 1 quantity 10.
I want to merge more records (quantity from child DS).
So I select other record (parent also, for example Record 2) that I want to use child 2 from that has quantity 5.
So the result needs to be
Record 1, CHild 1 qty 10, Child 2 qty 5
Record 2, Child 2 qty 0 (decreased since it is now part of Record 1)
And when I reopen the new form it should show only the child records that are merged, so no the ones that alreadi existed.
Please forget implementation details of your current solution for a moment and explain what you're trying to achieve from users' point of view. I'm unable to design a solution from what you told us so far, without knowing the bigger picture.
If you didn't join (or link) the child data source to the parent, then you have no join and no parent and a child. You have two independent data sources at the same level.
I removed it on purpose cause this child datasource should be actually showing data joined with caller form data source.
So, FORM A: Parent1 DS, Child1 DS
FORM B: Parent2 DS, CHild 2 DS
(but parent 1 and parent 2 are the same table, as well as child 1 and 2)
#1
André Arnaud de Cal...
294,217
Super User 2025 Season 1
#2
Martin Dráb
232,978
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
