I am making a receipt entry form which contains main form based on receipt table. This table contains field such as supplier, recdby and date etc. Another table contains details about receipts of various items (tblReceiptDetails) with one to many relationship and becomes rercordset for subform.
another table contains cost of individual item (tblReceiptCost). The purpose is, when a material arrives, store keeper can make entries of material in above form/subform. I want to keep freedom to user if he want to enter the costs later as sometimes costs are not readily available but I still want to keep inventory updated. I made a macro in subform where if user clicks twice another form should open which contain the recordset of cost table.
First, does my above practice is correct regarding split a table into details and costs (one to one) as I see that this RL is rare to use.
If no,please advise a recommended way.
If yes, still I have problem in updating common field automatically. I have tried same autonumber field as well as one autonumber and another indexed and required field.
appreciate your help.
best regards.
another table contains cost of individual item (tblReceiptCost). The purpose is, when a material arrives, store keeper can make entries of material in above form/subform. I want to keep freedom to user if he want to enter the costs later as sometimes costs are not readily available but I still want to keep inventory updated. I made a macro in subform where if user clicks twice another form should open which contain the recordset of cost table.
First, does my above practice is correct regarding split a table into details and costs (one to one) as I see that this RL is rare to use.
If no,please advise a recommended way.
If yes, still I have problem in updating common field automatically. I have tried same autonumber field as well as one autonumber and another indexed and required field.
appreciate your help.
best regards.