I created a small IDO and Form for testing as I hit an obstacle I wasn't expecting.
ID PK, Required, AUTONUMBER()
Code nvarchar(10), Required
Desc mvarchar(25), Required
I populated the form with multiple records and exported the data to csv.
What I can't do in Paste Rows Append data from the same csv. If I delete the data in the ID field because it is AUTONUMBER(), I get this.
| ID |
Material Code |
Material Code Description |
|
MN320H238 |
7050-T7451 Plate per AMS4050, BAC5439 CLS A |
|
Test |
Test |
If I Paste Rows Append by not copying the ID field in the data clipped from the csv, I get this.
| Material Code |
Material Code Description |
| MN320H238 |
7050-T7451 Plate per AMS4050, BAC5439 CLS A |
| Test |
Test |
If I supply an ID, SL definitely barks at that since it is an AUTONUMBER().
If I set a PK on a table/IDO with an default of AUTONUMBER(), can I not export and then report all the data? We are in the implementation phase and I will need this static data pushed to the prd.
Regards,
Lance
