parent/child grid components

[haven_sjc]

A relative newbie to A5, I have found a lot of great information on the message board � thank you to all, but I have not been able to find an answer to what is probably a dumb question, hence my first post.

This seems to be a straightforward situation on paper, but .....

The parent table (Batch Header) is related to the child table (Test Results) using a one to many relationship, joined on the Batch Header ID field, which is defined as an auto-increment field.

For the user to enter a new batch of test results, I have created a page with an �add records only� grid component to enter the Batch header data. (I know the parent page could use a dialog component, but I think I would still have the same dilemma.) Once the page is submitted, I want to redirect to a page with a grid-link component, parent grid to display the header data just submitted and the child �add records only� grid to allow the test results to be added to the child table.

As the Batch Header ID field is auto-increment, is there any way of capturing its value into a session/page variable, so that it is available in the child grid and written to the child records.

Am I missing something obvious or is this impossible?

[rleunis]

Re: parent/child grid components

If you just use the standard grid linker in which you define a parent child relationship, any inserts in the parent onece selected wil automatically result in child records with the linking parent id in them.

Attached an application I wrote in V7 which uses tabbed gridlinkers in complex/repeated 1 to N relationsships:

An organization can have several locations. Each location can have several departments. Each department can have several persons working in them.

When I enter new records in any of the child records, the parent id's are automatically substitued. No dialogues or additional xbasic required for this.

[haven_sjc]

Re: parent/child grid components

Thanks for your comments.

However I have no problem adding child records when the parent already exists - its when I want to add a new parent record and then the associated child records. The parent grid is set to 'add records only' so as soon as it is submitted, the data is gone and the child grid has nothing to link to.

The only way I can see to achieve this is to add the parent and then go to a different page to search for the parent just added, so I can add the children.

Surely there is a better way.

[rleunis]

Re: parent/child grid components

My setup works for some years now...

The parent grid has no restrictions like you: Only additions.

When I create a new parent grid, as soon as I have a view where I can select the newly created parent grid record, then child records are added to them.

You might have an issue where in the tabbed grid linker, the parent grid is not refreshed after the insert, thus giving you no view of the newly created records in the parent.

This can be solved by refreshing the page the parent grid is on ( i think it's something like response.redirect.)

[haven_sjc]

Re: parent/child grid components

Thanks Ron

Got it sorted - I think I was trying to make the solution more complicated than it actually was.