Linking

[ahines]

Is there a way for me to link information from two or more columns. (For
instance, my clients in my database are defined by letters (A.=Jones,
B.=Stein, C.=Joseph, etc.) and the type of transaction is defined by numbers
(1=Contract, 2=Litigation, 3=Letter). Is there a way to link the field so
that when it automatically assigns a number it also identifies the client and
type of transaction before the assigned number? (ie. A1-001).

 

[KARL DEWEY]

Yep. Just like this --
[Client] & [Transaction] & "-" & [AssignedNumber]

 

[aaron.kempf]

if you were using Access Data Projects; then you could use a single
'calculated column' to do this.

it would be quite easy to do this.

and then you could re-use this as a real key-- without any extra
effort-- in as many places as you wanted-- without giving you hell and
making you rewrite the function 100 different times; once in each
query.

MDB is for babies.. are you still stuck in the '90s?

lose the training wheels, kids

-Aaron Kempf
ADP Nationalist

 

[ahines]

HELP!!!! This is actually my first time working in Access designing a
database. I have had no formal training and I'm not sure how to incorporate
the formulas. Where would I incorporate it for it to generate in the chosen
column?

Yep. Just like this --
[Client] & [Transaction] & "-" & [AssignedNumber]

Is there a way for me to link information from two or more columns. (For
instance, my clients in my database are defined by letters (A.=Jones,
B.=Stein, C.=Joseph, etc.) and the type of transaction is defined by numbers
(1=Contract, 2=Litigation, 3=Letter). Is there a way to link the field so
that when it automatically assigns a number it also identifies the client and
type of transaction before the assigned number? (ie. A1-001).

 

[KARL DEWEY]

Open you existing query in design view. Scroll to the right until you see a
blank column. Enter the following in the Field: row --
Your new field label: [Client] & [Transaction] & "-" & [AssignedNumber]

HELP!!!! This is actually my first time working in Access designing a
database. I have had no formal training and I'm not sure how to incorporate
the formulas. Where would I incorporate it for it to generate in the chosen
column?

Yep. Just like this --
[Client] & [Transaction] & "-" & [AssignedNumber]

Is there a way for me to link information from two or more columns. (For
instance, my clients in my database are defined by letters (A.=Jones,
B.=Stein, C.=Joseph, etc.) and the type of transaction is defined by numbers
(1=Contract, 2=Litigation, 3=Letter). Is there a way to link the field so
that when it automatically assigns a number it also identifies the client and
type of transaction before the assigned number? (ie. A1-001).