I have a ticket system for trucks. Each ticket or parent has 1 or more
loads (children). I'm having trouble figuring out how to create a (parent)
and multiple children at the same time.
I'm trying to avoid going through a dialog where they have to fillout a
ticket, save, then add loads. I want to have a single screen where I can
create the parent and multiple children at the same time.
Here is my basic model:
# Ticket Information
db.define_table('ticket',
Field('type', db.loadtype),
Field('vehicle_id'),
Field('misc', 'text'),
Field('working', 'boolean'),
Field('approved', 'boolean')
)
db.ticket.type.requires = IS_IN_DB(db, 'loadtype.id', 'loadtype.type')
# Loads for a ticket (usually just one, but sometimes many)
db.define_table('load',
Field('ticket', db.ticket),
Field('container_id'),
Field('entered', 'datetime'),
Field('updated', 'datetime'),
Field('product', db.product)
)
Thanks for any help,
-Keith