Creating/editing tables

shane_holland
Mega Contributor

I must be missing something here that is potentially obvious.

 

Under System Definition, the only option I have for anything relating to "tables" is the Tables & Columns module. In here, you can add a new table but I can find no way to edit the table and enter data into it. The only buttons that display are "Schema Map" and "Delete All Records". Where can I define and edit a table?

1 ACCEPTED SOLUTION

Shane,



That depends on whether or not you created an application / module when you created the table.


If you created an application/module it will appear in the navigator for you to create new records in the table.
If you did not, you can actually open the table from the Tables & Columns module OR you can type the name of the table in the navigation search as follows: u_tablename.list and it will open the table


View solution in original post

6 REPLIES 6

danielbilling
Kilo Guru

go into the module you want to update.


Right-click and choose Personlize-> dictionary


here you can edit the fields


Hi Daniel,



I created a new table from the Tables & Columns module, but how do I then find and edit the table itself. As in, where can I find the table to open it?


Shane,



That depends on whether or not you created an application / module when you created the table.


If you created an application/module it will appear in the navigator for you to create new records in the table.
If you did not, you can actually open the table from the Tables & Columns module OR you can type the name of the table in the navigation search as follows: u_tablename.list and it will open the table


That's what I was looking for the: u_tablename.list



Thank you both!