Jump to content

One to Many Relationship troubles


charly
 Share

This topic is 6547 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have two files, one called People, another called Notes. What I need is for there to be many Notes records for one People record, but I can't seem to figure that one out... I have created one relationship from the People to the Notes with the "create related records" box checked, but it isn't letting me create many Notes records attached to one People record. I have several fields in the Notes file which are looked-up from the People file, for which I created a second relationship - is that where I went wrong? Or am I missing something really simple here?

Thanks in advance

Charly

Link to comment
Share on other sites

Hi Charly,

Have you created a portal on your layout yet? If not, create a portal (which is based on your relationship to your notes file). Because you've got your relationship set up to auto-create related records, your portal will always display a blank row at the bottom. When you click in a field in the portal on that blank row and start entering data, a new record will be created in the notes file that is associated with the people record you're currently viewing.

Link to comment
Share on other sites

Hello,

What are the keys you're using ? It should be PeronID matching PersonID in the Notes.fp5 file.

Also, your lookup may not work for the first related record if you don't exit the record after its creation (in the People file) prior to entering some values in the portal.

Link to comment
Share on other sites

This topic is 6547 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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