Jump to content
Sign in to follow this  

how to: creating new records from a found search

Recommended Posts

Hi there,

Could use any advise or pointers:

I have three tables

[media info]

[project] list of projects, project #1, #2, etc

[project track] details of each project, containing multiple media info through portal

Basically each Project track contains a list of media (50-100). My problem is that media info contains ~2000 records, and I want to search for specific criteria and then add those to project track.

The way I have it set up now is that [Project track] creates a new record based on the [Project List] record number and a unique identifier.

How can I sort through the records in Media Info, check them all (or some), add them to Project track, go back and sort some other criteria, add those again to Project track?

thanks in advance for any hints!


Share this post

Link to post
Share on other sites

You say that each project track contains a list of media (50-100) and yet according to your table structure, I see only one MediaID per Project Track. Is there supposed to be another join table btw Project Track and Media.

Anyhow, the method you need would be to use a popup filtered portal (filter by MediaType) that lets the user select Media_IDs. The user builds a global of MediaIDs by clicking an Add button which is on each portal row. Then, when they click Done, the script creates the join records, looping thru the global of IDs.

I'd offer a demo, but I'm not sure you have all the tables you need yet.

Share this post

Link to post
Share on other sites

Hi bcooney,

Thank you for the reply.

One project = many ProjectTrack

One ProjectTrack = one MediaInfo + other update information

I did not connect Project directly to Media Info because one Project may contain multiple of the same MediaInfo (maybe different reporter or different section of the media though).

I was thinking of something like this:

what I was thinking

but I don't have the chops to pull that off.

is that the right or wrong direction?


Share this post

Link to post
Share on other sites

I need some sample data to know if your model is correct. In your diagram, you have fields in the join table that seem to duplicate the fields in the Media table. Can you show me some sample Project and Media records? Maybe post a demo.

Share this post

Link to post
Share on other sites

Mike--This'll take me a bit--work got really busy. If anyone else wants to help out, please do.

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.