Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

More tables

Post Reply
milu
Posts: 2
Joined: Sat Jan 05, 2013 11:54 am

More tables

Unread post 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
admin
Site Admin
Posts: 2782
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 2 times

Re: More tables

Unread post 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
milu
Posts: 2
Joined: Sat Jan 05, 2013 11:54 am

Re: More tables

Unread post by milu »

Hello,
And if I have 7 tables,
How I solve the problem.
Thanks
admin
Site Admin
Posts: 2782
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 2 times

Re: More tables

Unread post 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
Post Reply