To start with, there are around ten tables for each process. The first process starts with the order received from the client; the info is stored in the first table. The second process is about an employee being assigned to carry out the reconnaissance, where he gets all the required information alongwith photographs. These information are stored in the second table where a unique id is given based on the recce sheet no. in which he fills in the details. The sizes, item description and qty related to this particular recce are stored in the third table. This table also contains rates, taxes and other relevant information. The path to a PPT file (which is the third process and where the photographs alongwith requirements, size and diagram is made) is stored in the fourth table. The fourth table contains design details alongwith the approval date. The fifth process is about preparing estimate for which the second table is used to store rates and other info. Now, after reviewing the estimate, the client sometimes makes changes to the item or material description or bargains for which a revised estimate has to be prepared. I am stuck over this. I can call the tables in the form, but I am unable to edit it.
The recordsource in the property sheet of the form is:
SELECT [qtyForformEdittblSizeQtyAsPerRecce].[Element], [qtyForformEdittblSizeQtyAsPerRecce].[ProjWidth], [qtyForformEdittblSizeQtyAsPerRecce].[ProjHeight], [qtyForformEdittblSizeQtyAsPerRecce].[ProjDepth], [qtyForformEdittblSizeQtyAsPerRecce].[Qty], [qtyForformEdittblSizeQtyAsPerRecce].[UOMDescription], [qtyForformEdittblSizeQtyAsPerRecce].[tblTotal], [qtyForformEdittblSizeQtyAsPerRecce].[HSNSACode], [qtyForformEdittblSizeQtyAsPerRecce].[ItemRate], [qtyForformEdittblSizeQtyAsPerRecce].[CGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[SGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[IGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[Est_Emp_Id], [qtyForformEdittblSizeQtyAsPerRecce].[Est_date] FROM [qtyForformEdittblSizeQtyAsPerRecce] WHERE [qtyForformEdittblSizeQtyAsPerRecce].[Recce_num]=[forms]![frmEstimateMain]!txttemprecnum ORDER BY ID ;
qtyForformEdittblSizeQtyAsPerRecce is a query table which uses multiple tables AND it is not editable.
Gina has suggested breaking up and using form/subform. Can someone guide me how to go about it.
The recordsource in the property sheet of the form is:
SELECT [qtyForformEdittblSizeQtyAsPerRecce].[Element], [qtyForformEdittblSizeQtyAsPerRecce].[ProjWidth], [qtyForformEdittblSizeQtyAsPerRecce].[ProjHeight], [qtyForformEdittblSizeQtyAsPerRecce].[ProjDepth], [qtyForformEdittblSizeQtyAsPerRecce].[Qty], [qtyForformEdittblSizeQtyAsPerRecce].[UOMDescription], [qtyForformEdittblSizeQtyAsPerRecce].[tblTotal], [qtyForformEdittblSizeQtyAsPerRecce].[HSNSACode], [qtyForformEdittblSizeQtyAsPerRecce].[ItemRate], [qtyForformEdittblSizeQtyAsPerRecce].[CGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[SGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[IGSTPercent], [qtyForformEdittblSizeQtyAsPerRecce].[Est_Emp_Id], [qtyForformEdittblSizeQtyAsPerRecce].[Est_date] FROM [qtyForformEdittblSizeQtyAsPerRecce] WHERE [qtyForformEdittblSizeQtyAsPerRecce].[Recce_num]=[forms]![frmEstimateMain]!txttemprecnum ORDER BY ID ;
qtyForformEdittblSizeQtyAsPerRecce is a query table which uses multiple tables AND it is not editable.
Gina has suggested breaking up and using form/subform. Can someone guide me how to go about it.