Need Help Wtih Forms

[Access N00b]

Alright so I am very new to using access and I have been given the task of
making an inventory and vendor database for a company. I have a couple of
tables, a few forms, and a couple of Reports. Problem is that I do not know
how to integrate them with one another or how to get my information to
properly display.
Alright say that I have a column title "Part #", but I also want the
number ordered to be displayed with it. I have the parts listed in each row
of the column as xasx,n098sd, sada98. And say that the corresponding numbers
ordered are 34,13, and 8 for those specific parts. Is there any way to get
them to be linked with each other on a report? Is there a way to make
sub-rows for me to list the numbers ordered under each item number?

 

[Beetle]

Alright so I am very new to using access and I have been given the task of

making an inventory and vendor database for a company.

Not necessarily an easy task for someone with little or no experience with
Access. It all starts with the data, or rather, how you have the data stored.
A "couple of tables" doesn't sound like enough, but it's hard to say without
knowing more about your app. If you post some more details about your
structure, someone may be able to give some guidance.

 

[PJHAction]

It appears you may have to forget about the forms and head to table
design.

I have my main Table

field = [customer name]
field = [product purchased]

Sub Table

field = [product purchased]

note: create a one to many relationship to house all your product
purchased

Form:

customer field

Sub form is [product purchased] showing many products purchased

peter