Does my decision of one to one RL is correct.

mahenkj2

Registered User.
Local time
Tomorrow, 02:55
Joined
Apr 20, 2012
Messages
459
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.
 
This is not a case for a 1-1 relationship. Just put the cost field in the details table.
 
Thanks for your reply.

I made a single table now but if I keep required property of cost fields "Yes" then I must update all fields in one time. How to tackle this. As I mentioned earlier, user would like to enter some data first and later remaining data.

Basically, I intend to fill the partial data from one form and once I send command from this form, another form should open to capture remaining field's data. Hope I am able to explain my requirement.

best regards.
 
Why you just make the required property "No" for the cost field?
 
If that is just the way, I would go for that. As I am very new to access, I think there may be some other ways and I wanted to explore those.

best regards.
 
Finally I made a single table and in fact I could solve some issues which I was facing last few days just because of this one to one kind thing. I think I made simple things complicated. Anyway, thank you all.

best regards.
 

Users who are viewing this thread

Back
Top Bottom