I'm having trouble getting a handle on this.
I have a form that visitors to a site fill out requesting an "investigation". Our Case Administrator then goes through the details of the request and determines whether or not to open a case. At this point she "moves" the data from one mySql table to several others (breaking out organizations and individuals into separate files).
OK, here's the deal. We would like to provide a "lookup" window to let the Case Administrator see if a particular Individual or Organization already exists with the ability to select an existing record, update that record, or create a new record.
Now, I don't have a clue on how to pass parameters from one page to another. In the hyperlink button that calls the lookup window I have two variables being passed and I'm fairly sure that it's set up properly - the URL generated is "TEAM_Lookup_Main.htm?Type='Contact'&Xref='TxtContactXRefKey'" so I seem to be passing the variables Type and Xref to the new window.
I can't seem to retrieve those variables on the next page. I'm thinking that the problem might be because "TEAM_Lookup_Main.htm" is a FRAMES page with three frames: a heading html page with our site logo, etc., and two php pages where I do the lookups based on the type and updating the XRefKey array.
I've tried putting code in the frames page and the first php window. Ive tried making the frames page a php page and that didn't seem to work either -- and to be honest, I'm not even sure WHAT code to use to parse out the QUERY arguments from the URL since I haven't done it before.
I would like to create ONE lookup since I have five different types that use the same tables, but they each have slightly different requirements for the XRefKey array.
I thank you all in advance for any light you can shed on this for me.
Jerry Stephen