move an item from list box to another list box in one form (1 Viewer)

[Hema1]

I want to learn how to move an item from list box to another list box in one form, and how to extract the sum of the price field in list box to another field in the form, like this picture. Here is an example.

 

[Minty]

You were given a potential solution here:

copy all selctead item from list box from table to another list box

i need move all selctead item from combo box to another combo box

www.access-programmers.co.uk

What didn't work about that?

 

[Hema1]

You were given a potential solution here:

copy all selctead item from list box from table to another list box

i need move all selctead item from combo box to another combo box

www.access-programmers.co.uk

What didn't work about that?

This solution is not quite what I want
I want when I select an item from a listbox whose data source is a table, move to another listbox and all records move to another table.
If you notice the image, only the name of the analysis is transferred, apparently to the second list box, but in reality, it transfers all the records related to this item, such as the price field, which appears in the image to be collected in the main form, and this is what I want.

 

[MajP]

That is because your tables are a non-normalized disaster.
It does not move just the name it creates a linked record.

 

[MajP]

Noone should waste anytime on this request until you fix the tables. If not total waste of time.

 

[Hema1]

Noone should waste anytime on this request until you fix the tables. If not total waste

i fineshed moving item from list to another but i need to link by id ,code without primary key

 

[MajP]

Need to read about database normalization. This does not make any sense to me. But what do I know?