Transfer data by from 1Division 2another by checkbox selection?

[Azad, DH, BD]

Dear all Experts,
I'm seeking your kind help in transfering data (fixed assets) from one
division to another Division of a company.I want, in an entry form, I will
select (by combo) the division from which I like to transfer to another
division.then I'll select(by combo) item code. Then the form should show the
available items of the division with checkbox so that I can select (checking
box) some or all items for transfer to other division.

Then by clicking a command button, all the selected (selected by checkbox)
items should be deleted from the one division and should be added to other
division.

pls help. Thanks in advance.

Azad, Dhaka, Bangladesh

 

[John W. Vinson]

Dear all Experts,
I'm seeking your kind help in transfering data (fixed assets) from one
division to another Division of a company.I want, in an entry form, I will
select (by combo) the division from which I like to transfer to another
division.then I'll select(by combo) item code. Then the form should show the
available items of the division with checkbox so that I can select (checking
box) some or all items for transfer to other division.

Then by clicking a command button, all the selected (selected by checkbox)
items should be deleted from the one division and should be added to other
division.

pls help. Thanks in advance.

Azad, Dhaka, Bangladesh

If you have a separate table for each division...

*your table structure is WRONG*.

You did not post the structure of your tables, but I'd see a table of Assets
(all assets) with just a field for the division that asset belongs to. Then
you can simply change the value of that field, using a combo box.

If this doesn't make sense please post your table structures.

 

[Azad, DH, BD]

If you have a separate table for each division...

*your table structure is WRONG*.

You did not post the structure of your tables, but I'd see a table of Assets
(all assets) with just a field for the division that asset belongs to. Then
you can simply change the value of that field, using a combo box.

If this doesn't make sense please post your table structures.

Thanks for instatnt reply.Yes I do have the same table with a field for the
division code. if I change the division code by combo box then only one item
will be transfered and I've to do the same thing repeatedly for all the items
of same code and different serials. but I have several items and also same
item with different serials no. I 'd like to show the all items of same code
but different serials available in the that division and then I'll select by
checkbox all items or may be some of the items for transfer. Pls help me out
ASAP.

actually, I need the solution in the way I described above. Otherwise, I
could do it in the way you have advised. I 'm and will remain grateful to you
all for all of your invalueable helps and advice.

My table structer is: Fields:---Div code,Item code,item
serial,Qty,Price,supplier


Thanx once again indeed.
Azad, DH, BD

 

[Azad, DH, BD]

My table structer is: Fields:---Div code,Item code,item
serial,Qty,Price,supplier


actually, I need the solution in the way like an email inbox.The mails list
with having a checkbox at the left for each to select. Similarly,the entry
form will show the available items with a checkbox at the left for each to
select (item code selected from the combobox of the same form) of the
division (division code also selected from the combobox of the same form) . I
'm and will remain grateful to you
all for all of your invalueable helps and advice