How can I create one form that saves up to 37 different values but to different tables depending on which user is signed in?
I have Users who have to fill out several reports while they are logged in. Each report has numerous lookup wizards necessary to input values from lookup tables for many fields.
One table has 37 different fields. This table is not altered or updated much but it is editable and is the MASTER table that is consulted and referenced while 4 different report forms are filled out.
To be interpreted visually this Master table has quite a few look up tables necessary to "read" the text values when it is displayed since these cell values are numbers referencing the look up tables.
I have say, 7 users, who log in to fill out their own reports. I would like them to be able to use one form in common for each report. So, that would be 4 different reports that must be saved to 4 different tables.
When each user logs in they will find 4 tabs with their names and the table or report name.
One Tab is for the Master table with 37 fields. The other 3 tabs represent 3 separate forms/tables and are for what would be termed Children in a relationship view to the master table.
When User Sally is logged in she looks up only "her" records in the Master Table. But when she files a report the "reporter_id" number saved into that table will her unique id.
I would like to not only use one form for all Users per Report --- 3 separate Report tables holding the data -- but, to specify that the SAVE or INSERT go to a different table that is "hers" or "his".
So, on SAVE or INSERT Form 1 values get written to "user_1_report_A".
If Bob is logged in he uses the same form but on SAVE or INSERT Form 1 values get written to "user_2_report_A".
And when Sally fills in Form 2 on SAVE or INSERT her values get written to "user_1_report_B"
When Bob is logged in and fills in Form 2 on SAVE or INSERT his values get written to "user_2_report_B".
This is what HAS to happen for this situation.
I am looking for ways to streamline building a PHPRunner project!
Thanks so much!
