I have an ADD form that will write to a reporting table that only belongs to that user. So User Charlotte_K writes to a table called "reporting_charlotte". Same individual table setup for five different users. In this "reporting_charlotte" table is a field called "detailer_id"..just a short numeric to hold a number-- Charlotte is "1". This value is from a lookup table called "detailer" used for storing her dealerid, name, address, login password, etc.
When Charlotte fills out a new report it has to save her detailer id number "1" and because "reporting_charlotte" has an auto-increment unique index field it will automatically save the new ID.
So in this form I want the top row value in a vertically aligned form to ALREADY indicate...label: Detailer Name -- Charlotte
Next row has a Dropdown of the different Doctors that could be assigned that is generated by the Lookup Wizard.
In the VIEW lists I have used the Lookup Wizard to show the text wording for fields that take numeric values but have a longer text "reader friendly" definitions.
But in the ADD pages I want some fields to already contain values...to already be filled out when the ADD Record link is clicked and a new form shows up. And although the field shows "user friendly" text, it is actually submitting the numeric value that is linked to a lookup table where the text is also stored.
But in this ADD form I cannot get a STATIC value from the same kind of lookup that the Lookup Wizard uses to show text values instead of field numbers.
To get Charlotte's name for a brand new record in the "reporting_charlotte" table I have to use the ID number for her in the "detailer" table and then show the "Name" text field in that table.
Lookup wizard does a nice job of that connection but it makes a Dropdown with all other detailer names from the detailer table-- I just want this form to submit her Detailer_ID, but for the field to already be filled out with the detailer_id lookup...her Name.
I know this is a query but it seems like this information must be already available in the global values while Charlotte is filling out and saving forms.
Thank you for showing me what must be a pretty simple solution.
In "normal" PHP pages I would write a query to the table, specify that the "where" value was either fixed or determined by an on-page session value, and substitute the return "detailer_name" field value but I just do not know yet how PHPRunner cooperates with such basic code. It assembles pages unlike any php generator I have seen before.
Thanks for your help!