Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CListObjEdit unique values
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00101756
Message ID:
00102551
Views:
23
>Jose,
>
>>Suppose that I have an application, with 3 main tables :
>>
>>1) Employees (id_employee);
>>2) Hobbies (id_hobby);
>>3) Employee's hobbies (id_employee_hobby, id_employee, id_hobby).
>>
>>So I have a cListObjMaintenanceForm with all Emploee's data and in a third page of a pageframe, I have a cListObj containing the employee's hobbies.
>>When I want to insert a new hobbie, I have a cListObjEditForm with a combobox populate by a "Hobbies" BizObj. When I click "Ok" to save my new hobby insertion, I want to be able to check if this hobby was not already inserted for "this employee".>
>
>I recommend that you use a MoverBox rather than a combobox for this type of data entry. This is a bit friendlier for the user because they can see a list of "available" hobbies on the left box and a list of "selected" hobbies in the right box.
>
>In the sample Project Manager application check out the "Groups" tab of the "Users" form to see a live example of how this can be done. This tab demonstrates how to handle a many-to-many relationship which includes a users table, a groups table and a link table...similar to your scenario.
>
>You can also check out the section on "KMoverObj" in the Mere Mortals Developer's Guide for instructions on setting this up.
>
>Regards,

Good Idea. I'll try it.

Regards,
José Augusto Cavalcanti
Global Connection
jose.cavalcanti@globalconnection.com.br
Previous
Reply
Map
View

Click here to load this message in the networking platform