Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping Two tables with multiple equal items

Status
Not open for further replies.

Xzibit7

Technical User
Jun 20, 2006
172
US
I need to be able to group two tables. One will be inputed by the supervisor. Then employees will use one of three inputs that the supervisor makes to add data to another table. I have tried alot of different things to accomplish this including making an update query that updates the users table with the information in the three categories for the supervisor. I have also tried an incremented key that is updated to group these tables together. This seems like a very basic problem but I can't seem to figure it out.
 
I could get this to work when there was only one criteria to group by ie (part number)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top