Jump to content
Sign in to follow this  
funkatudinal

noob question about relationships

Recommended Posts

I have 3 tables in my PR database:

media information (key=MediaName)

journalists (key=Journalist)

project (key=ProjectName)

media information has multiple journalists in a portal

in project I would like to (theoretically!) be able to choose 20-50 of the MediaName into a list, and have project related fieldsfor each MediaName. It should also be able to bring in information from Journalists.

Could you recommend the correct, or smart way to set this up? I am really a beginner so apologies for such a noob question, but do appreciate any help.

Share this post


Link to post
Share on other sites

Thank you -- I analyzed your posts/files, and also hit the books myself (FM Bible, Missing Manual).

I now have the basic db setup. I have two questions, if you could point me in the right direction.

1) in table ProjectTrack I have Go to Related Records running so that it only shows those records with same Project ID from Project. I want to automatically insert that ProjectID number from the table Project for every new record. For some reason it is just not working.

2) this may be too difficult for my skills, but I would also like to insert a bunch of data from table Media Info into this table as new records. Ideally I could select the media I want from Media Info, sort it, and then add these as new records automatically into Project Track.

Enclosed are 2 screen shots....thanks anyone for helping out or pointing in the right direction.

RG.jpg

table.ProjectTrack.jpg

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.