Yes I was just reading and understood that the reason for my fields not
showing up was because the fields in many of the tables have the same
names. Changing that resolved that issue.
It's actually a great book too, just wished I could read faster.
Thanks.
On Tue, Jun 18, 2013 at 1:04 PM, Richard Vézina <ml.richard.vez...@gmail.com
> wrote:
> I think you have 1 form for 3 tables...
>
> You should package a dummy app with the code above to help us helping
> you...
>
> As far as I understand you got the id only because you didn't set requires
> in your model. Read the book about validators and search for "requires" in
> the book.
>
> Richard
>
>
> On Tue, Jun 18, 2013 at 11:40 AM, <t...@caregointl.com> wrote:
>
>> I have one page where I want to show 3 forms. I have a main table with 2
>> tables that are related to it.
>>
>> So in my models file I have:
>>
>> db.define_table(
>> 'dependents',
>> Field('dep_id',db.patient),
>> Field('first_name'),
>> Field('middle_name'),
>> Field('last_name'),
>> Field('relationship', 'text'))
>>
>> db.define_table(
>> 'emergencycontacts',
>> Field('ec_id',db.patient),
>> Field('first_name'),
>> Field('middle_name'),
>> Field('last_name'),
>> Field('address1'),
>> Field('address2'),
>> Field('city'),
>> Field('state'),
>> Field('zipcode'),
>> Field('country'),
>> Field('phone'),
>> Field('relationship'))
>>
>> And db.patient is another table.
>>
>> So in my form I have:
>>
>> def register_patient():
>> form=SQLFORM.factory(db.patient,db.emergencycontacts, db.dependents)
>> if form.process().accepted:
>> id = db.patient.insert(**db.patient._filter_fields(form.vars))
>> form.vars.patient=id
>> id =
>> db.emergencycontacts.insert(**db.emergencycontacts._filter_fields(form.vars))
>> response.flash='Thanks for filling the form'
>> id =
>> db.dependents.insert(**db.dependents._filter_fields(form.vars))
>> form.vars.dependents=id
>> # and get a list of all persons
>> records =
>> SQLTABLE(db().select(db.patient.ALL),headers='fieldname:capitalize')
>>
>> return dict(form=form, records=records)
>>
>> So the form displays correctly but I was expecting that the other fields
>> for dependents and emergencycontacts would be there for input as well but I
>> only get the id fields showing up for input.
>>
>> Am I doing what I want to do incorrectly?
>>
>> Thanks,
>>
>> Tom
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
