I think I've confused myself...
Ok, I hope I can explain what I'm trying to do.
I have two forms.
(Form 1)The first form is for writers to submit screenplays to my company. (works great)
(Form 2)The second form is a form for my readers to complete a review of submitted works.
In form 2, I have two lookup fields. One that looks up data from form 1 (screenplay title and author) and one field that looks up data from a different database (Staff).
A writer can submit a script and that works fine.
A reader can submit a review and that works fine.
I can create a list of all of the screenplays submitted to us.
I can't seem to create a list of screenplays that have not been reviewed yet.
That is my issue.
I can't think of a logical way to do this.
I was thinking of putting a hidden field on the (Form 1) that gets updated when a review is submitted but I don't know how to write data to a different form from another form. I know how to get data (Look up) but not send it.
I have given access to support if you want to take a look at it and see what I'm talking about. Look for the application Screenplay Manager.
Basically, I want to create a new view of the two forms combined that lists the screenplays that have not been reviewed.
Maybe there is a way to change the dropdown I created in FORM 2 to list only unreviewed scripts???
I probably just confused you too...