General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Best way to add data
I have as part of my app a document creation module. The user will initiate the document by suppling a number. My app inserts this document number into a table. Then a form displays the new document with fields in upper portion of the form displaying the main document data. I have a grid on the form based on a view of another table which holds items used by the document, both tables are linked by document number. I have a button on the form with which I insert one record into the view, requery the grid source. The user can type in the document items in that record. Pressing the button again will add a second record and so forth. This is slow because of the updating the view every time a record is changed.
Is there a better way?
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