Move Employee Multiple employee (1 Viewer)

E

eyeseven2014

New member

Local time

Today, 01:03

Joined

Apr 3, 2014

Messages

8

• Apr 3, 2014

• #1

HI guys!

I have a employee database which has different group, what i am trying achieve is how can i make a command button that can move multiple (selected) users to other group.

for example :

i have 10 users and 3 groups, i want to move 3 users in group 1 by selecting the users then click the move button.

please help! Thank You!

 

jdraw

Super Moderator

Staff member

Local time

Today, 04:03

Joined

Jan 23, 2006

Messages

15,378

• Apr 3, 2014

• #2

Tell us more about your database and table design.
Do you have a Group table and a UserTable? If so, you'll need a third table

tblUser
userId
username
other user info

tblGroupContainsUsers
GroupID
UserId

TblGroup
GroupId
GroupName
GroupDescription

 

E

eyeseven2014

New member

Local time

Today, 01:03

Joined

Apr 3, 2014

Messages

8

• Apr 3, 2014

• #3

Hi jdraw,

yes, i have a group table and the usertable.

What should i do after creating tblGroupContainsUsers?

Thanks so much!

 

E

eyeseven2014

New member

Local time

Today, 01:03

Joined

Apr 3, 2014

Messages

8

• Apr 7, 2014

• #4

Hi guys!

do you have any solution here! PLease help! Thanks so much!