AnsweredAssumed Answered

Related Tables problem

Question asked by jhc on Sep 24, 2013
Latest reply on Oct 18, 2013 by philmodjunk

Title

Related Tables problem

Post

     I'm having trouble making my tables relate. I have attached my ERD (relationship tables). 

     I want the user to be able to enter info for a lake. And then enter info for one (or more than one) net site. The net site may have many fish in it. so it's a series of 1:M 

     I tried portals but my tables are too big - the fields just go way past the layout area (i'm trying to make this for an iPad). I also tried tabs and that seems to work but couldn't figure out how to make the user be able to pick which lake his/her net site belongs to or which net his/her fish was caught in.

     I thought I was making progress when I discovered portals but I feel like I've gone backwards now and am no closer to figuring this out. Anyone with any words of wisdom? 

     please & thank you

lakeCatchDB_reltsp.JPG

Outcomes