mixing the table view into a form/report

[Guest]

I know forms/reports are ultimately just manipulating a table, but here's
what I would like to do and hopefully you can help me. What i would like to
do is create a form for users to manipulate (and ultimately a report with the
same design) which contains an upper header where you can enter customer,
part number, date, etc. information. Then I need the main portion of the form
to enter 16 columns worth of information (in a table view). Essentially what
I need to do is to contain what would normally be 11 entries worth of
information (i need 11 rows each with those 16 columns), in just one entry.
All of the 11 entries that I want to put in the table are all related just to
that one customer, part number, etc.

I have tried messing around with the sub-form, but have only ended up
confusing myself. Any help would be greatly appreciated.

 

[jahoobob via AccessMonster.com]

Is this for order entry or invoicing or something similar? If it is, look at
the Northwinds db. I think you want two tables for this data for what you
are tyring to do, an Invoice table and an Item table.