timcadieux Posted April 3, 2009 Share Posted April 3, 2009 Hi folkz, I have to clean up a database of Military Units and the members of each. Alot of the units appear more than once but with alternate spelling, what I was hoping to do was check the number of members in each duplicate unit, find out which one already has the most members, than just transfer the members from the other units into that one and delete the old ones. To do this I was thinking populating a ListMenu with all the units and somehow make each name clickable, which would then just give me the number of members from a lookup. Then seperatly, I would create 2 other list menu that had a MOVE to button, this would take all the members of the Clicked On group and send them into the Unit which I would have to click on in the second ListMenu. Ii hope this is clearer than mud. Anyhow, I'm looking for better ideas, if not, pointers on how to make the ListMenu show me the Count of the Members and then pointers on how I can write the Query which would take all the members from box 1 and add them as Members of what I click in box 2. Thx in advance.!!! Link to comment https://forums.phpfreaks.com/topic/152415-looking-for-some-pointers/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.