How to make an already created custom table extend another custom table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-11-2015 01:39 AM
How to make an already created custom table extend another custom table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2015 02:37 AM
Hi Upasana,
Your records are not deleted so you won't get those in the deleted records module. As you have modified the table it extends the records are not shown here but they are still present in the table it was extending.
To get the records back try setting the 'extends table' field value of the extending table back to what it was earlier. This will show you the records back in the table.
Export all the records in excel and then do what you want.
But instead of changing the 'extends table' value of already existing table I would recommend deleting this table and creating exact table again(this time extending the table which you want) and then import the excel you exported earlier into this table. To extend any table make sure the extensible field is checked on that table you want to extend.
Follow these steps after taking excel export-
1. Go to System Definition > Tables.
2. In the list view set the extensible to true for the table which you want to extend.
3. Create the deleted table again(as told above) this time extending the table in step 2.
4. Import your data into your new table using Easy Import.
Thanks,
Tanaji Patil
--Mark correct/helpful if it helps solving your issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2015 03:05 AM
Hi Tanaji,
I am not able to view the records after changing the extended table back to what it was earlier. It showed unique key vioalation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2015 03:13 AM
Please delete data/customization added after you changed the extends table value and try.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2015 03:34 AM
No customization was done. Though its showing error, it should have shown the list of records right?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2015 03:45 AM
Yes it should show the records. Hope you are making 'Table Field Validation' BR active false and setting the 'extends table' value to exactly what it was when the records were created.
I checked again on demo021 and I was right. It shows the records back.
Tables used are Table 1 and Table 2.
If this is not helping you then you should go with raising HI ticket.
Thanks,
Tanaji Patil
--Mark correct/helpful if it helps you solving your issue.
