SQL Datasource read/write

[Nick Monsour]

HELP PELASE!


Is it possible to read and write from/to the SQL database data source
that a form is based on?
The issue is if I have information in a database that I wish to display
I would use a query field and that would populate my existing data
files (read only text boxes). Then I wish to add information to the
database tables and I don't want to display the information that the
query would have returned. I want to have blank text boxes that the
form user could enter new information into. How would I keep these
fields from populating?

Thank you,
Nick

 

[em]

hi,
I'm not sure to understand your question - but if you want to add "new
elements" to be send to your database - just use the standard context menu to
add new, blank elements to your form which can be filled by the user.
regards
em

 

[Nick Monsour]

What I mean is I want to display information that exists in a table
based on a query field (lets say employee information) and then I want
to display the same fields but blank for data entry. Here is the
scenario: an employee has access to computer systems so there is a User
employee information table joined to a user_system table (system
information i.e. system name, date added, logon id, password) and the
system names are populated by a look up table to avoid a large and
static number of columns in a single table. I want to modify a users
system access information so I query on the user and have a repeating
table shows what accesses they currently have and then below I want to
have a repeating table with blank drop down lists and user_sytem text
boxes that will still accept information but that did not populate when
the query above is run.
What is happening is when the query is run all fields are populating
with the employee information. So how do I keep the fields I want bound
to the same tables but blank?

Thanks