Glad it's working for you now.

no problem. Glad to have been of some humble assistance :) V. (MQOTD rules and previous solutions) OriginalGriff wrote: V is absolutely right

Thanks Alan, I am at present using button column. Actually this textbox with button idea is the inspiration from some popular Accounting softwares. They use in variety of there data entry forms, like for e.g Invoice, when user enter line item, there is column ProductID, when user enters ProductID column he/she can directly enter Product ID or use the ellipse button to show a lookup form. This looks cool, so I thought may be there are some ways we can do it in C# winforms, and by the look of all posts here I am now sure there are more then one ways. Thanks to all for helping me..I am trying to learn to create custom control, and if there is no success I will stick to button column approach.

Thanks....I will try this...

Thanks...I will follow your guidelines..

ahmed_one wrote: which is only known by me. That's the problem. You should not have access to other people's passwords, end of story. ahmed_one wrote: I am only a beginner trying to learn from experience masters like you. If you did, you'd be asking for explanation on the salt. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Aaa...now I see where the misunderstanding starts... Actually the requirement is not to do the Data entry via dialog but to get data from Dialog/list to DataGridView. That is why I need the listview at first place. The main form contain DataGridView, from which user can make data entry for each product. Which is working just fine for saving/editing/deleting data to database. What I need to provide facility to the data entry process, and give the user a list to select product instead of typing ProductID, user can select product from list and it will copy to Datagridview's active Row alongwith its ProductDesc, the list should only show when user enter ProductID in DataGridView.

Trak4Net wrote: I am not an accountant nor have I ever worked on any accounting software, but I have dealt with database applications a lot. Your suggested records per year of 50-80K will definitely not be an issue for a database table on platforms like MySQL or MSSQL or Oracle or the likes, unless you are running wide open queries such as (select * from table) without any filter or limitation on rows returned. Database design can become complicated if you want a very efficient means of storing your data. You may look over your required data several times and see if there are relations to break out into separate tables as much as possible and use primary keys, foreign keys and joins to bring your data together. Such as your "year" you could create a table that contains a primary key, year identifier and other year associated data and then that primary key would be a foreign key in your transaction table to match those transactions to that year etc.   Hopefully that kind of makes some sense and helps in some way. Very nice guidelines, I will definitely follow them, thanks a lot.

Thanks for the links, I will try to follow guidelines from both.. Appreciate your help. regards Ahmed

You're welcome :)

This helps a lot....big thanks...

ahmed_one wrote: My problem is OrderID is not generated because of error that child table is not saved.. Save the Order first, fetch the identity, save the child-records. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]