Load data from one table to another.

[HyperOsmar]

Colleagues, greetings...

I have two lists (lists, forms, elements) identical, but with different database tables...

List 001 - Form 001 - {tablebd_001}
- Element 001 (Dropdown);
- Element 002 (Dropdown);
- Element 003 (Dropdown);
- Element 004 (Dropdown)...


List 002 - Form 002 - {tablebd_002}
- Element 001 (Dropdown);
- Element 002 (Dropdown);
- Element 003 (Dropdown);
- Element 004 (Dropdown)...

What do I want???...

Form 001: will be typed by the user and the data will be saved in {tablebd_001}. These data cannot be changed after registration.

Form 002: this will load the data registered in Form 001 {tablebd_001}, but with the option to change, and saved in {tablebd_002}.

Can someone help me???

 

[juuser]

In Form/List 001:
1) Add upsert form plugin to insert List/Form 001 data to List/Form 002. Or use form php-plugin to have more flexibility.
2) Set list access "Edit records" to "No-one", or whatever access level the user does not belong to.

In Form/List 002:
1) Just allow editing records.

Note that when data is changed in Form 002 it will not be synchronized to Form 001. For that you would need a form plugin also in Form 002 to update changed data back to Form 001.

So, if you need synced data, you could just use two copies of the same table pointing to same database table.