One order with some uploaded images

[startpoint]

I want to make application for user orders. Each order will have several fields. Each order must have uploaded images from the user. After sending the user should be able to reorder the uploaded images. Possible to adjust certain amounts already filled fields. Once everything is OK to finalize your order. Then you can not edit, but can only delete it or create a new order.

I made the following example:
I created these two lists

list 'orders'
id
date_time
username
.
.
.
some fields

list "images"
id
date_time
order_id
ordering
image_upload

After LEFT Join list 'orders' with list 'images' I have a problem uploading the images. Also not possible to reorder uploaded images.

Something I missed or should some other approach?
Do I have to use the content plugin?

Thanks in advance for your help.

 

[felixkat]

No you don't have to use the content plugin.

How have you performed the join?

How are you controlling the re-order process?

 

[startpoint]

I created join in list 'order' as follows:
'order' LEFT JOIN 'images' ON 'id'='order_id'.
For example:
http://tentprint.tk/index.php/order
In this way when i uploaded some images file path not saved in database.
If you add images one by one from "images" list view , then recorded in database. This way I can to re-order.
For example:
http://tentprint.tk/index.php/images-list
If I put a image and I selected out that it is for specific order, that's okay. But if you edit this order after its save, data file is deleted.

?ccess data for my site is filled in the section "My sites".

 

[cheesegrits]

I'm looking to see if I can replicate this locally.

-- hugh