Setting Up UD User Tables and Forms
UD User Table and Form Setup creates custom tables and forms for records that standard Vista forms do not track.
Before you start
- Know the columns, keys, and whether records are company-specific.
- Plan who will get form security access.
Steps
- Open UD User Table and Form Setup and create a new form.
- Name the table starting with
ud(for exampleudMyTable). - Enter a description (appears on the menu).
- Check Company-based if records are per company.
- Enable Auditing to track changes; typically enable standard notes as well.
- On the Grid tab, add columns—no spaces in column names.
- Mark unique key columns with key sequence values.
- Prefer existing data types so related lookups come along.
- Save, then click Update Table to generate the table and form.
- Grant access in VA Form Security (user group or individual).
Notes
- Save before Update Table so you do not lose definition work.
- Careless key definitions allow duplicates—define keys deliberately.