Author Topic: Multiple Table, same Form, multiple Tabs  (Read 2933 times)

orgtec

  • Newbie
  • *
  • Posts: 15
    • View Profile
Multiple Table, same Form, multiple Tabs
« on: March 12, 2014, 05:16:46 PM »
Hello,
I'm trying to make a Form with 4 Tabs with the follwing functions:

Tab1- Choice of Salesman as a base for the other Tabs. Salesman Profile, Table Salesman
Tab2- Clients based on Salesman choice in Tab 1 in a subform. Client Profile, Table Clients
Tab3- Articles- List of Articles based on choice of Family, put Article in a subform linked to Family. On choice of Article, shows availability from stocks. Profile Articles, Profile Family, Tables Family and Articles
Tab4- Stocks- List of Articles with availabilty. Profile Stocks, Table Stocks

Eventually create a Tab5 for Order by Client choice in Tab2, acumulation based on choice of Article on Tab3.

What it looks is that after I associate first Profile with Form, I cannot associate any more profiles, unless I put the second Profile in a subform.

So Tab 1 and 2 will work, but 3 and 4 does not because I cannot use a subform within a subform on Tab3 and Stocks has nothing to do with the initial coosen Profile.

How to get around this?

Hope I made myself clear.
I can provide a file with images of the Cellica manager and forms.

orgtec@orgtec.pt

Thanks in advance for the help.
Carlos

CellicaTeam

  • Administrator
  • Hero Member
  • *****
  • Posts: 693
    • View Profile
Re: Multiple Table, same Form, multiple Tabs
« Reply #1 on: March 13, 2014, 12:48:40 AM »
Hello Carlos,

You can use more than 2 tables content on a form by using different controls and properties of form controls.

1) Lookup Combobox: Please find more information on following link,
http://cellica.kayako.com/Knowledgebase/Article/View/34/0/how-can-i-select-from-a-list-of-values-what-are-different-options-available-to-use-combo-box-control-on-form-in-cellica-database

2) Lookup Property: Please find more information on following link,
http://cellica.kayako.com/Knowledgebase/Article/View/44/0/what-is-lookup-mapping-property-available-for-controls-on-form-how-to-use-data-in-another-profilestables-while-add-and-update-record-on-forms

3) Subform Control: Please find more information on following link,
http://cellica.kayako.com/Knowledgebase/Article/View/54/0/how-to-use-subform-control-to-create-master-details-relationship-between-tables-in-cellica-database

4) Button control with "Go To Form" Action ( Most probable solution for your requirement): Please find more information on following link,
http://cellica.kayako.com/Knowledgebase/Article/View/55/0/how-to-implement-multilevel-relationship-between-tables-in-cellica-database-using-go-to-form-feature

If you have any questions or issues, please mail us at support@cellica.com

Thank You,
Cellica Support Team

orgtec

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Multiple Table, same Form, multiple Tabs
« Reply #2 on: March 13, 2014, 11:51:07 AM »
Tanks for the help, did resolve initial issues that were indicated.