I have a form that is pointed to an empty table, Im calling it my "Staging Table". This empty table is a duplicate in structure to a live table that has data in it.
I have Detail Grids in the "Master/Detail" section of Scriptcase that use a variable I pass to this form in order to display the current data for the matching record from the live table.
Scriptcase will not load the Detail grids unless a record exists in the staging table for that RecNum.
Is there a way to get scriptcase to load the details even though there is no record in the staging table yet?
Example table structure. First row is the Field Names.
LIVE TABLE
STAGING TABLE
I am using this to create a database where users can make suggestions as to what a fields value should be..... so the user could click on RecNbr 1 and see the values that are live but enter their own values into the STAGING table. Where I will record the values and their user ID for reference.
I don't want to resort to creating a bunch of Empty rows in the STAGING table.... is there another way?
Thanks for any suggestions.
I have Detail Grids in the "Master/Detail" section of Scriptcase that use a variable I pass to this form in order to display the current data for the matching record from the live table.
Scriptcase will not load the Detail grids unless a record exists in the staging table for that RecNum.
Is there a way to get scriptcase to load the details even though there is no record in the staging table yet?
Example table structure. First row is the Field Names.
LIVE TABLE
RecNbr | Size | Color |
1 | L | Red |
2 | S |
RecNbr | Size | Color | UserID |
I don't want to resort to creating a bunch of Empty rows in the STAGING table.... is there another way?
Thanks for any suggestions.
Comment