Data Designer

Use the Data Designer to design new tables and indexes or modify existing ones. You can call the Data Designer directly from the Data Explorer to alter specific tables.

Keep in mind that a table design is just the definition of a table structure. To create or alter a physical database table you have to explicitly click the create or alter button. Saving a table design does not change any existing physical database table or index structures.

Want to modify an existing table? Use reverse engineering to create a table design from an existing table or just click the ALTER button in the Data Explorer. Indexes are taken into account as well. After that you can modify your structure and recreate the table or create a new table with another name.

Want to save your old table? Copy or rename it in the Data Explorer!

Want to add a listbox to your form?
Use an enum or list column.
Put your values between single quotes!

For example: ‘Yes’,’No’ ( See support topic 11411195, Decentris, Hannes)

Read this topic on the support forum the learn how to add a listbox to your data entry form.

Was this article helpful to you? Yes No