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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Merging 2 columns in 2 dif tables; sorted by a shared column
Pretty close. I have a warehouse with multiple bins there can be multiple inventory items per bin... This access database is for an import into another program. So I had to format the location entries in Locations a specific way and now i need to tie those entries to bin name (aka LocName...- BexodusMT
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Merging 2 columns in 2 dif tables; sorted by a shared column
Thank you for the link Fneily. That link explained a bit of gray area to me. To clarify my tables: tblLocations ID Primary Key location specific LocationID Foreign Key (maybe?) Description tblInvLoc Inv_No Primary Key inventory specific LocationID Foreign Key (blank but needs...- BexodusMT
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Merging 2 columns in 2 dif tables; sorted by a shared column
I'm rather new to Access and kind of flying by the seat of my pants. I know how to create very basic update queries, so any answer given I'd LOVE if you could dumb it down a bit. I'm a kinetic learner... I have 2 tables. InvLocs and Locations... I need to get the location cells into the...- BexodusMT
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
