Jump to content
Sign in to follow this  
nedzb

Using a Portal to Create Records in Related Tables Simaltaneously

Recommended Posts

Newbie question:

I'm developing a solution for kids to track the environmental effects of certain waste items. Each item will have many "choices": recycle, send to landfill, etc. Each choice will have many impacts: energy, water, mineral resources, etc. Please see attached PDF.

Ideally, I'd like to enter in all this information in one layout: the waste item, it's choices for disposal, and each choices' many impacts.

I've been successful in using a basic portal for entering in an item's many choices but not attaching the many impacts to each single choice.

Any help would be greatly appreciated. Thanks!

ElementsOfWaste.pdf

portal_set_up.jpg

Share this post


Link to post
Share on other sites

my first response to a topic thats not mine i think so take with a pinch of salt lol.

How about making the fields within the impacts table as repeating? then i 'think' you can include those fields within the choices portal. Or you may be able to create a new portal for the impacts table, and include that within the choice table, not sure if that would work, but i vaguely remember being able to place a portal within a portal.

remember to tick the 'allow creation of records' in the relationship setting.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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