Designing a form using several tables, including changeable default values???

J

Joseph

I need to design a form that will allow default data to be loaded from
a table with a userID. Data on some other fields to be validated from
an other table. Additional record fields, where data needs to be
entered. And one Date field where the data entered will remain until
changed. All data fields, other than the userID should editable.
The record(s) generated gets saved in its own table.
Summary:
- Date data remains in Form until changed. (Keyed in)
- UserID data, remains in Form until UserID gets changed (Default
loaded from the User Table, changeable, but in form only for that
User)
- Some other data fields to be validated from Validation data table(s)
- Additional data keyed into non-controlled fields.

The data in the form to be saved as a record in an other table.

Any advise or pointers will be appreciated.

Joseph Rudigier
 
Top