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

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.