Form Question (Access 2010)->(I'm desperate!)

[Xonos]

Access 2010 64bit

This is simple I am sure however considering I am new to Access, I do not know the proper terminology to search for this (as I have tried). Perhaps someone could point me to the right direction to find out how to do this...

Ok, so I have a table that contains orders (Bill of Ladings) and in the Bill table, there is a one-to-many relationship with the Bill of Lading Products table. I have all of the "Bill of Lading Table" information in the header of a report however I need to insert multiple blocks of specifically formatted information from the corresponding Bill of Lading Products table. I have attached a screenshot that I photoshopped real quick of what I have so far and what I want to add to the detail section of the report.

So I guess my question is, what terminology would I use to search for this particular need? I know how people are on forums pleading that new members use search before wasting others time so I ask you this rather than exactly how to do it. Forgive me if the image is too large, I have many monitors. Oh and by the way, I do realize my database is in SERIOUS need of normalization but for now - considering my deadline... this will have to happen once I complete the project so that I can dedicate the time to learn how to properly do this.

[aytee111]

What is your actual need?

Here are some things you can do straight off:
- put the parent information on the detail part of the form.
- create a subform for the child information and add that to the detail part of the form
- link the two forms (Properties - Link Master/Link Child)

[Xonos]

I've worked a bit with sub forms however what I need is what you see in the detail portion of the page. I drew all of that in photoshop real quick... How do I get the linked table fields (Bill of Lading Product Details Table) to format the way I want (like you see in the example) and automatically add a new section per each row that matches by [BOL Identification ID]<1---8>[BOL ID] (as you can see the one-to-many relationship on the right). It works perfectly with list boxes, sub forms and other related objects but I don't know the terminology for what it is that I want.


So, let's assume in the report with the primary source being the [Bill of Ladings] table - the filter applied is [BOL Identification ID] = 22.

[HEADER]
In the header, it will display Shipper and Recipient information as well as a few fields that belong to [Bill of Ladings] table.
----------------------------- I already have this part working flawlessly.... but the next part, I don't yet understand.
[DETAILS]
In the details section, I want specifically formatted rows displaying the related rows between [Bill of Ladings] table and [BOL Product Details] to populate as a list like you can see in the example.

1.> [BOL Product Details] where [BOL ID] = [BOL Identification ID]
2.> [BOL Product Details] where [BOL ID] = [BOL Identification ID]
3.> [BOL Product Details] where [BOL ID] = [BOL Identification ID]
4.> [BOL Product Details] where [BOL ID] = [BOL Identification ID]
5.> and so on...

So, if there are only 3 matching rows in the [BOL Product Details] table, only 3 sections will appear displaying the corresponding data. - In the example, you'll see what I mean by "Specifically Formatted".. I mean that I want Units, Weight, UOM, Product Name and other related information to appear in specific positions per each result.

[aytee111]

A subform will do this for you - what is your difficulty with them? Can I help you to create it?

[Xonos]

Well, would I use a subform on a report? I have all of my forms created for adding, deleting and managing the table data. My difficulty is not understanding the process to add what I need to the detail of the report. Do I create a subform or a sub report? And if I do that, how do I get it to repeat the information formatted exactly the way I want it?

[aytee111]

You design the subform, or the subreport, in the exact format that you want the fields to be displayed. You put the child table/query as the record source. On the main form or report the record source will be the parent table/query. Then you link the main to the sub by using the Link properties - the fields you use to link with will be whatever is common between the two and what you want the sub to be filtered by. Hope this is making better sense.

[Xonos]

Ahhhhh... You're right. It automatically expanded... Thank you very very much for your help!