A
andyd273
I have an info path form that saves to and reads from a SQL Server
database table.
Occasionally someone will make a mistake when saving to the table and
I'll have to go in and delete the record.
Here is the table structure:
StdID (int, primary key, unique, auto )
CustomerID (int, foreign key)
RONumber (string)
stdDate (Date)
The problem is that the main lookup field that they use is the
RONumber, which unfortunately can't be unique.
So I created a view with a repeating section that will show the
results of a lookup query, and each instance of the repeating section
has a delete button.
The problem with that is that the delete button deletes all of the
returned records, not just the one you want.
How do I create a delete button that only deletes a single database
record, even if there are multiple records with the same RO number?
database table.
Occasionally someone will make a mistake when saving to the table and
I'll have to go in and delete the record.
Here is the table structure:
StdID (int, primary key, unique, auto )
CustomerID (int, foreign key)
RONumber (string)
stdDate (Date)
The problem is that the main lookup field that they use is the
RONumber, which unfortunately can't be unique.
So I created a view with a repeating section that will show the
results of a lookup query, and each instance of the repeating section
has a delete button.
The problem with that is that the delete button deletes all of the
returned records, not just the one you want.
How do I create a delete button that only deletes a single database
record, even if there are multiple records with the same RO number?