Simple subform?

[mrodent]

Hi,

Me again, still following doggedly through the videos but also having looked at the Wiki (and done some googling).

The thing about the illustrated subform in the videos (video 5) is that it is linking a form to a subform through an intermediate table, because this is a many-to-many Customer <-> Product relationship. But the simpler case with subforms is a one-to-many relationship, e.g. Customer -> emails. I may be a bit slow but I just haven't been able to work out how to do this ... partly at least because the primary key of a form you make seems by default to be concealed... so how can your subform reference it?

PS I really think Nubuilder is fantastic... I've been looking for this for years and sincerely believe it will let me escape the clutches of a certain producer of proprietary OSs and proprietary RDBMSs and transition to Linux. Once I've got over these teething troubles I intend to put together something akin to "Nubuilder for dummies".

[admin]

mrodent,

Here is a link to a new demo we have created..

https://secure.nubuilder.com/db3/livedemo/

you can log in as

username : globeadmin
password : nu

or

username : user
password : user

You will be able to see the code on the invoice subform and follow how it works.

Or download this and try it yourself.

invoicing.sql.zip

Steven

[mrodent]

thanks

[admin]

.