self join
db.define_table('ni', Field('ni_01', 'references ni'), Field('ni_02',
'references ni'))
Perhaps you should consider this structure
TABLE NI
part_number
cust_id
of_id
picture_id
desc
TABLE KIT
name
desc
TABLE NI_KIT
ID_NI
ID_KIT
-Thadeus
http://thadeusb.com
On Sun, Sep 13, 2009 at 5:18 PM, Leandro - ProfessionalIT <
[email protected]> wrote:
>
> I have this fields for the NI table:
>
> ni
> part_number
> customer_id
> of_id
> picture_id
> description
> is_kit
> ni_01
> ni_02
> ni_03
> ni_04
> ni_05
> ni_06
>
> The fields ni_01, ni_02, ni_03, ni_04, ni_05 and ni_06 are 'ni'
> type fields. Well, and I still have the situation where if is_kit
> field is true then the user can associate the ni_01...ni_06 with
> existents ni's.
>
> In my mind this a case of a self join, correct ? Then, how to
> implements this in Web2Py ?
>
>
> PS: Sorry by terrible english !,
>
> Leandro.
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
