Page 1 of 1

More tables

Posted: Sun Jan 06, 2013 4:33 pm
by milu
Hi,

I want to know, how i can join more tables (i mean subform in subform in form).

example:

Form contain Groups or Group Table. I click on one Group this group contain a subform (Customers) now it is possible to choose one Customer from subform ? and to show his Projects and it is possible to click or to choose one Projects and to show his tasks ... ?

Thanks

Re: More tables

Posted: Mon Jan 07, 2013 3:24 am
by admin
milu,

I think this is what you want to do..

Main Form

Group > Customer > Project

If you know the customer why would you pick group first?

If you make the main Form Customer with a Dropdown or Lookup for Group, you only need one Subform for Project.

Group < Customer > Project

Group can still be searched for within the Browse Form.

Steven

Re: More tables

Posted: Mon Jan 07, 2013 12:54 pm
by milu
Hello,
And if I have 7 tables,
How I solve the problem.
Thanks

Re: More tables

Posted: Tue Jan 08, 2013 2:10 am
by admin
milu,

You have changed the question.

You can't put a subform in another subform.

If that's your question?

This might help

http://forums.nubuilder.cloud/viewtopic.p ... 59&p=11007

Steven