Sub-form Question!

[tstarkie]

Hoping I've put this in the right place!!

I've successfully setup a customer form which has multiple sub-forms embedded into it showing results from various tables within my db, all linked to the customer via the master/child link I've setup...

This all works perfectly, however I've now been asked whether I can show two different tables worth of results in the same sub-form, and for the life of me I cannot get it to work!

For example, the master form lets me pick which customer I wish to view... I then have four sub-forms within this form, each showing results from different tables, and they all populate automatically based on the chosen customer in the master form. For one sub-form it currently shows a [drawn] table with part numbers along the top, and then the total volume purchased underneath each part which is pulled from my volume table. But I now need it to show another line in the [drawn] table for the value in £ spend of each part listed also, which comes from yet another table in my db. I've tried linking both tables to the sub-form via the master/child link, and also tried a query, but cannot seem to get it to show the data for both tables in the [drawn] table...

Any ideas - or this not possible and requires another sub-form to be created?

Thanks!

 

[Estuardo]

G'd afternoon,
build a query and make it the source of your subform [drawn] table and keep the relation master-child form. It should work.

 

[tstarkie]

G'd afternoon,
build a query and make it the source of your subform [drawn] table and keep the relation master-child form. It should work.

Afternoon Estuardo!

Thanks for your response. I've tried that but it doesn't seem to work?
I have a query setup which is the entirety of the two tables [value] and [volume] - Both tables are exactly the same in layout, i.e. an Account Number as the identifier and then about 30 different part numbers as headers; but one obviously shows the sold value and one volume.

I've then created a relationship between the Account Number in both tables so that the data links up all on one line, but when I go to link the Master/Child fields in the subform, it only allows me to link between ONE of the Account Number references for instance from the [value] table, then the data for the [volume] table wont show because it's only linking for the [value] data?

Does that make any sense?

 

[Estuardo]

Can you post a copy of your DB without any sensitive data? or at least with the relevant forms?