Jump to content
Sign in to follow this  
Steve Schmid

using layouts to add multiple rows for child tables

Recommended Posts

Hello folksm, quick question

I have a parent table Incident Report with two child tables: sanction and charge

How can i design my layout so that I can add multiple charges and/or sanction for each incident number? I want to be able to add in 1 or more charges and sanctions, then use a portal to view all related records for an incident number.

Share this post


Link to post
Share on other sites

Oh yeah one thing to note....

the business process is set up so half thre incident report info comes in with the charge info

later on the last half of the incident report info comes in with the sanction information.

So i have two layouts, both are linked to incident report with either charge or sanction info on the bottom half.

I want this to be user friendly in that the user can add the multiple charges or sanctions on the bottom of the layout without having to repeatedly key in the incident number up top. Can this be done with FMP?

Share this post


Link to post
Share on other sites

With your current structure, you would have to have two portals to show the related information (a portal can only be based on one TO).

If you wanted a common portal to show both Charges and Sanctions, those would both need to be stored in the same table. This only makes sense if the data is similar for Charges and Sanctions, or if this common portal/report list is very important. If Charges and Sanctions are in the same table, they can be differentiated with a Type field, and its records can be filtered by use of that field and global filters on the parent side of the respective Charges or Sanctions relationships.

Share this post


Link to post
Share on other sites

Thanks a ton i got it all figured out now. Part of my problem was with the relationships. I did not have the primary keys properly designated.

I ended up placing a portal on each one of the tables and it properly created multiple records in the child tables.

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ron n 
×

Important Information

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