Multiple entry into one record source

[keyitan]

Hi, im a newbie towards access and I need help on how could i do towards creating a AWB having multiple carton dimension to be entered in a form. Sample Codes/ File please i tried on northwind but i could not solve it. Please do help.


I need to enter this datas towards a main form which is filled with AWB,Invoice number, suppliers, disposition.
Example
SUbform

AWB NoOfCarton Length breadth Height
1111 2 3 2 3

1111 2 2 5 8

[Robeen]

keyitan - could you please explain using different words?

What I CAN understand [I think] is that you have a Main Form and a Sub form? Is that correct?
And you want to use data that is on one of those forms and . . . here's where you will have to be a little more clear about what you want to do.
Otherwise it is difficult to understand.

[keyitan]

Yes correct, I have a main form which I have to key in all necessary data, then in that form I wish to enter number of carton in that main form, then in the sub form I wish to enter the dimension of each carton.

[Robeen]

I think you should read this article - it will really help you & then I believe you will be able to do what you need to.
http://office.microsoft.com/en-ca/ac...005187803.aspx

Let me know if you have more questions after you read the article.

[keyitan]

Hi Robeen,

I have done accoording towards the article that you show me, everything have been done and it seems to be working fine,

just a small question, any idea how could i key in multiple carton dimension without keying in multiple AWB(primary key to link to the main form with one to many relationship)

[Robeen]

When I have used this method, the way it is set up, the Main Form stays on a certain 'master record' and on the sub form - I can just enter as many records as I need and they get added to the repated table.
In my case, I do not have the key field [the one that relates the child form to the main form] on the sub form. Access automatically inserts each record in the sub form along with the key value from the Main form.
You should be able to do the same thing. Do you have the AWB field on the Main form AND the Child form?

[keyitan]

Yes, have tried to add in AWB field on both main and child form. With relationships this could let the table to auto insert each record in the sub form to the key value from the main form! Thank you! You solved my problem which i had think for weeks! Thank you!!!

[Robeen]

Happy that I could help, keyitan! All the best!

[jillpang]

Hi, I am a newbie and I am having a similar problem as keyitin on this thread. I have created an inventory database using the template in acces 2010. In the product form, I am entering product with the same name values and differt part numbers. I am entering the product name in the product code, and visa versa. When I enter the same name items, (in the product code area) I am getting an error, "dupicate information not allowed primary key error" In layout view I looked at the properties listand do not see where I can change/add for duplicates ok. In 2003 It was easy to find, not in 2010. Please help I am racking my brain.

[Robeen]

Hi Jillpang!

The 'Duplicate information not allowed . . .' usually comes from trying to enter the same value into a Table when the field in the table has the 'Indexed' Property [In Table -> Design View] set to 'Yes (No Duplicates)'.

In the Table where you want to be able to enter different PartNumbers for the same Product - go to Design View -> Click on the Product field -> Look below in Field Properties / General Tab -> Indexed.
Hope this helps. Let me know if you still need help.

If you want to ask questions - start a new thread rather than posting your question in another thread. That way, if anyone else has the same question as you - they will be able to find the solution by looking at your thread.

All the Best!