Jump to content
Sign in to follow this  
JRStudent

navigation from parent to child

Recommended Posts

Hi, I have a parent table and a child table. The parent table has a number key called CLID and the child table has a number key called CHID. In the child table I have a second number field called CLID so that in the Relationship I can link the parent and the child. On the Relationship screen it looks good, the parent and child have a one-to-many relationship. Am I doing ok so far?

Then on the layout for the parent, I have a button which I would like to navigate to the related child records. So I went through the steps in the setup, related field, specify the record and layout, options: show only related records and match current record only.

Is this right? It must not be because it doesn't work. When I press the button on the parent layout in browse it doesn't go anywhere. Maybe because there are no related records currently in the child table? I need a way to add records if there aren't any currently.

Thank you. You guys have really been helping me!!

Share this post


Link to post
Share on other sites

What I'm seeing is that on the parent layout you have a portal to the child. On that portal you can enter a value for a child (the child id is automatically entered) then you can go to related record (gtrr button) where presumably you would enter more info into child record.

The portal is required for entering a child attached to the parent?

Sorry, I'm feeling like a dummy on this. The reference book I have doesn't address it.

Share this post


Link to post
Share on other sites

The portal is just ONE method to create a child, and automatically assign it to the current parent record (note that the relationship is set to allow this). But you can also create a new child in the Child table, and assign it manually to a parent. Or you could have a script do this for you.

Share this post


Link to post
Share on other sites

It looks like I got it to work using portals.

Your example helped a lot.

I have a lot to learn and everyone in this forum has been helping me so much.

Thank you!

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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