Two Subforms

Hi All, I have a Form with a Subform, like Purchase Order. What i want is to insert a second Subform which refers to Data which is shown in the first Subform. Is there a way to solve something like that? The Problem is the Communication between these Subforms. When i change to another record in Subform one other Records in Subform two should be shown. Any Ideas out there? Thanks in advance. Greetings, Frank

Hi Frank! What about a Subform in the Subform!?--------------------MainForm-------------------- | | ----------SubForm---------- | | -----SubSubForm----- | | Regards, Jörg

Hi Jörg, Thanks for your reply. Have you ever tried this??? I think that this is impossible, isn’t it? Greetings, Frank

Hi, U can not use a sub-form in a sub-form. Use Matrix Box in the sub-form.

Hi Girish, Cool Idea, thanks. I will try it and place a reply if it works (for my case). Greetings, Frank

Check the posting at http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=6953 it is not exactly what you are after, but it was done for the same reason.

Hello FPulsfort, I have several times done a similar kind of form using a table control, a subform and “manually” getting the header info. The table control should be the source table. One problem however is that e.g pagedown for next record only works for the table control and not the header info. The header info I program the user to choose using either lookup or entering e.g. customer code directly in a control. Another problem is if you want to modify the header info. Then you will have to write the code your self. br Anders

I had a client with a genuine need to have a sub form on the Sales Line of a Sales order. It was a must have, so the solution was as follows. Create a mainform based on the Sales line table, it looks just like the Sales Header, except that where the tabs are is blank. Then create a sub form based on the Sales Header, which has all the tabs in it. Add code to filter the SalesLines based on the current Document No. Move all the buttons to work at the line level etc… etc… Now you can add a sub form to the SalesLine form. Its a lot of work, and you need a real good reason to do it. The page up down selection is a nightmare, and there is a lot of code. I don’t even have the original objects anywhere. Try it at your own risk.

Borrowing from Jörg’s fancy graphical interpretation, it would look something like: |------------------SubForm--------------------| | | | |---MainForm---| |----SubSubForm----| | | | | | | | | |--------------| |------------------| | | | |---------------------------------------------| Thinking back though, I find it hard to believe I really did something so silly.

quote:


What about a Subform in the Subform!?


Shame on me, it’s not possible … I’ve tried it …[:I] Jörg

At first: Thanks to all for your answers!!! David, I think i have to do something similar to your solution. The hardest thing is to build the Page Up/Down and F3/F4 Funcions for the Header-Table, which is no longer sourceTable of the form. Can you give me an advice, how you manage this, please? Greeting, Frank

Hello David,

I am a student and doing an internship in Itzehoe, Germany. I am trying to redesign the service order form so that the service technicians can use it with out a complication in the company. I have run in to the problem of sorting data in a subform based on a record of another subform. I have seen on this forum that you have suggested a solution before. I would like to get some more hints on this if it is possible please.

This is the problem

I have a Form with a Subform, like Service Order. What i want is to insert a second Subform (Service Line) which refers to Data which is shown in the first Subform (Service Item Line). Is there a way to solve something like that?

Or can I get the selected field value (eg Line No. of the Service Item Line subform) and assign this value to a variable then use this variable value to set a filter in the other subform (in the Service Line subform) so that the data can be filtered and displayed based on the variable value.

Thank you

suresh

Suresh, please define the business requirement, not the code requirement.

Sorry, I did not get the meaning of THE BUSINESS REQUIREMENT?

The main reason that the company wants to implement it that way is to keep the forms as simple as possible and also did not want to change the lay out of the form much.

But to start with, I have adopted the following idea, but still for my understanding and shake of learning I still would love to know how it is possible to sort data in a Subform, which refers to Data that is shown in another Subform

|------------------SubForm------------------------|
|                                                                         | 
|  |---MainForm---|   |----SubSubForm---|    |
|  |                          |   |                                  |    | 
|  |-------------------|    |--------------------------|   |
|                                                                         | 
|-------------------------------------------------------|

thanks
Suresh