Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 29th, 2004, 05:37 PM
Authorized User
 
Join Date: Mar 2004
Location: Orange County, California, USA.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default How Do I Concatinate fields into a key field

I am pulling information from three different tables into a new table.

Tables:
Job_Master
Vendor_Master
Insurance_Master
Job_Detail

Example: On my form I have a combo boxes that I use for searching for the job_number from my Job_Master table, Vendor_Abbrev from the Vendor_Master table and the Insurance_number from the Insurance_Master table. I then want to save this newly formed key and these fields into the Job_Detail table.

How can this be done?

 
Old May 3rd, 2004, 03:00 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

In order for you to accomplish you have to create a query that will join all tables, select * from from the table and add the additonal field needed.

TBL1 TBL2
PR_NUM ITEM_NUM

Product_num:[PR_NUM] & [ITEM_NUM]

Remember to base your combo box on the query.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Field/Key Concatenation latinoloco Access 1 May 15th, 2006 08:30 AM
How to drop a field with primary key jeffcflam Pro VB Databases 1 May 4th, 2006 01:51 PM
insert concatinate string problem :( meemee SQL Server 2000 2 February 11th, 2004 09:05 PM
When more than one field in a primery key - DGrid ManoYaka ASP.NET 1.0 and 1.1 Basics 3 January 21st, 2004 09:27 AM
Mulitple fields primary key ksa266 Access VBA 1 December 15th, 2003 10:13 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.