Re: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup field

 

Hi John,

Would you first explain the logic of why you want to do this?  And what kind of data do you have? Thanks

Warm Regards,
Crystal

Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access

 *
   (: have an awesome day :)
 *

________________________________
From: yshopper
Subject: [MS_AccessPros] Concatenate Auto-sequence number field and Lookup field

I have an auto-sequence number field that I need to concatenate with a Lookup text box on a form.

I got the auto-number to work and the lookup is on the form, but how do I concatenate the 2 fields that are in 2 different tables that are related  only through another table?

I see how to do it with fields in the same table, but not with fields in different tables.

TIA,
John

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 9
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___