related fields / mixed view

[Hannes]

Hi Ben,

everything is fine and I was very happy to hear about your recent formtools plans for the summer.

What we *really* need is a button on the Registration form's Edit Submission page saying "Create Order". This would create a new entry in the Order form table, link to it, and populate the values for the mapped fields. That way you could even make the View that you're linked to in the Order form have those fields non-editable, like you suggested.

I am not sure if we are thinking about the same solution:
I am very glad that there is a solution for this: http://forums.formtools.org/showthread.php?tid=951
But what I want now in addition is not a single field related to another view/form, I want to have a full submission with all the fields related to it...

For the example above it would look like this:

I have a database "registration" with a record like this:

Code:

registration.submission_id: 1
registration.name: Hannes
registration.street: Habersaathstr. 1
registration.city: Berlin
registration.email: guest@gmx.net

And I have a form "order" where i am asked about:

Code:

order.costumer (related with registration.name): Hannes
order.amount: 20
order.article: 3

If I now add a costumer "Hannes" it will save the following to the database:

Code:

order.costumer: 1 (submission_id from record "Hannes" in "registration" database)
order.amount: 20
order.article: 3

So even if the user will change its name and address it will be still related to the order.
Since I have a field which is related to to another database, I should now be able to select fields from both databases to a view for "order":

Code:

selected fields:
registration.name (not editable)
registration.street (not editable)
registration.city (not editable)
registration.email (not editable)
order.amount
order.article

The only things that you have to take care is that you can only relate to fields which are unique in order to have exactly one submission_id which is related and only to records which can not be deleted.

Hope it is a bit clearer now what i mean ...and of course I will be happy with 2.1 also without this feature... maybe in 2.1.1...?

Thanks a lot! I keep following the project and I am getting more and more excited about the first release of 2.1.

Best regards from grey and rainy Berlin
(in May it hopefully will be nice and sunny all over Europe),
Hannes