Fething Mutilple Records from SQL Server Table on Form for CRUD

[sacacompany]

Hi guy just trying to fetch invoice data from sql server table that has multiple rows in it so that i van edit the prices and other fields and then update the rows back to sql server table. but no luck...i tried main form and sub form with combo that is built on same table invoice number but its not working/ would be grateful if someone share best practices in this regard

 

[GPGeorge]

Hi guy just trying to fetch invoice data from sql server table that has multiple rows in it so that i van edit the prices and other fields and then update the rows back to sql server table. but no luck...i tried main form and sub form with combo that is built on same table invoice number but its not working/ would be grateful if someone share best practices in this regard

Bound forms are usually the most effective way to accomplish tasks like this.

 

[Pat Hartman]

but its not working/

What does that mean? Error message? A cat jumped out on your keyboard? Wrong answer? No answer?