Hello to all of you,
I have created an order booking program for a clothing store which has a
There is a main form and a sub forms located in it. In the main form, customer related information is entered, while in the sub form, the shed and meter related to the cloths ordered are entered. The data of main form is entered in the gray offer table and the data of sub form is entered in the gray shade table.
There are total four fields in the gray shade table, one is auto number, second is gray ID, third is shade and fourth is meter. The gray ID field is created for greyoffer table to table relation.
1. I want that whenever a new order is entered, in addition to the shed and meter, a serial number field should also be shown temporarily in ascending order in the sub form.
2. When the user open any old record in for editing and make any row empty by deleting shade and meter from any row in the sub form, then that empty row is unnecessarily shown in the print preview. I want that if the user deletes the data of any row from the sub form during editing, So that row itself should be removed from the table.
Please give your suggestions.
Thank you.