Creating a form that retrieves a paragraph of data?

[birpal]

Hello everyone, I need help creating a user-form that retrieves data from a database, using the Product # as the common attribute. The issue I'm having is every Product# has about 2-10 rows of data divided by 3 columns.

Each column is: Qty, Length, and Width

Ans the multiple rows represent the many dimensions of the varied separate parts needed to assemble the product.

I need to be able to create a form in which I can enter and retrieve data in the form for 3 columns and 2-10 rows of data.
Can someone please tell me what I need to do in order to create this form?

[ranman256]

you need a master/child form...and a master table and a child table.

the master form/table will have the product#
the child form will allow you to enter X rows, 3 columns.

[Micron]

Create a select query before you worry about forms or reports. Then you can use a form wizard to create a form based on the query. Some pointers:
- DON'T use special characters in your names (#)
- don't settle for the default names that an Access wizard gives to any form or report.
- check these out for starters
http://www.access-programmers.co.uk/...d.php?t=225837
http://allenbrowne.com/AppIssueBadWord.html

Edit: since I ended up being the second to post, I'll add that a continuous or data sheet form should also work if you have a way to feed the aforementioned query the product number; such as an input form which provides a means to pass the product number to the query when the continuous/datasheet form calls that query. Easier than I'm making it sound.

[birpal]

Thank you the both of you "Micron" and "ranman256" I really appreciate the help, I am very new to Access - someone recommended this program over Excel so I took the endeavor of using this program to create this. I will get back to you when I've attempted all of your suggestions.