General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Quick and dirty ADD for dozens of tables
Environment versions
Network:
Windows 2000 Server
I have dozens of small and infrequently used tables (remote SQL views) that I need a quick way to develop an ADD form. It does NOT have to be pretty.
I thought of haveing a PRG that is called with file number
Then a Case statement to open correct table.
I hoped I could use only one generic ADD Form.
Open the database before I call the form.
Append blank at form load
Use EDIT command to show fields (this is a new record and not yet updated)
Put two command button at bottom Save & Cancel
Save has a tableupdate(), Cancel has Tablerevert()
Then thisform.release
YES, this is crude but quick to build.
Question: on EDIT command, can I put it on a Form and can I limit user to editing just that one record?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only