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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Save data into join table from two main tables
Thanks.. I am doing something similar.. Actually i ended up using a subform where PK1 and PK2 are combo boxes with PK2 as lookup to the Statustext from Table2. The subform is joined to master fields on PK1=PK1. I can use the dropdown in subform to change status text and it saves the new...- Nautlilus
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Save data into join table from two main tables
Hi, This must be a very common scenario for a lot of situations but i cant seem to find a simple solution for it. I have two tables with item data and status text and then a join table with just the primary keys from these two tables. Table1 (PK1, Item, item_desc, Item_location...- Nautlilus
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
