(sub)Form on temporary table

[shuray]

Hi everyone!

Suppose I have a SQL table:

Code: Select all

GROUP   MONTH   OBJECT
=====   =====   ======
1       Jan     apple
1       Jan     orange
1       Feb     apple
1       Feb     orange

2       March   plum

3       March   cherry
...

i.e. each group number contains full cross of Month and Object

I would like to have a form with two subforms, each of them has an editable grid with ability to modity a list:

Code: Select all

+---------------------------------
MAIN FORM for Group 1:

 Subform of Months
	[Jan  ]
	[Feb  ]
	[     ]

 Subform of Objects
	[apple  ]
	[orange ]
	[       ]
+---------------------------------

I can make SQL select in BeroreEdit of a main form and populate two temporary tables (one for months, another for objects) and place subforms based on that selections on the main form. But how to specify the temporary table as Table Name property of the subform?

Could you please advise an approach to solve this problem?

Thank you

[Enric]

With SQL builder you have to filter the table based on the column. Check how "relations" work in software like Microsoft Aceess and you will understand... is the same

[kev1n]

Would it be possible to add some screenshots with annotations so I can better understand what you are trying to achieve?