One field from two fields

[Adiankur via AccessMonster.com]

I would like to have a field in one of my tables, formed from two other
fields.
example is,
table one has a clients information and idcode, which is the primary key
linking it to the authorizations table.
the authorizations table has an, authorization number field, and a service
code field as each authorization number can have up to 5 differing service
codes. what I would like is the best way to make those two fields combine
themselves to fill a third field which I can use to interact with a third
table, Billing.
My questions are, can I do this without forcing a user to manually enter this
data into this third field? Can this third field exist in the table were the
donor fields exist? finally, does this post make sense? I hope I was clear
and thanks for any imput.

 

[Guest]

Hi,

The third field, combining data from two other fields is essentially a
calculated field in a table and may not be such a good idea. Why not use an
autonumber field in your authorisation table as the primary key? Something
like AuthorisationID. That way, as your users enter an authorisation number
and service code, Access automatically generates the AuthorisationID, which
you can then use in the biling and any other related tables.

Delordson Kallon
www.instantsoftwaretraining.com

 

[Adiankur via AccessMonster.com]

Yeah, thats probably a good idea. the funny thing is, in the original table
I designed, I had an autonumbered field, but figured that having an id that
ran with the familiar service codes and auth ids that we already use would be
easier to track, but now that you mention it, it makes more sense to go back
to what I had, as I can easily use the auto number to tie in the tables,
while making what appears on my forms the actual data and field information I
can recognize.
Thanks for the help. Sometimes, in an attempt to make things better, one can
just make things more complicated. Im sure ill be back with more questions
as I go along.

Hi,

The third field, combining data from two other fields is essentially a
calculated field in a table and may not be such a good idea. Why not use an
autonumber field in your authorisation table as the primary key? Something
like AuthorisationID. That way, as your users enter an authorisation number
and service code, Access automatically generates the AuthorisationID, which
you can then use in the biling and any other related tables.

Delordson Kallon
www.instantsoftwaretraining.com

I would like to have a field in one of my tables, formed from two other
fields.

[quoted text clipped - 10 lines]

donor fields exist? finally, does this post make sense? I hope I was clear
and thanks for any imput.

 

[Guest]

No Problem. Good luck with your project.

Delordson

Yeah, thats probably a good idea. the funny thing is, in the original table
I designed, I had an autonumbered field, but figured that having an id that
ran with the familiar service codes and auth ids that we already use would be
easier to track, but now that you mention it, it makes more sense to go back
to what I had, as I can easily use the auto number to tie in the tables,
while making what appears on my forms the actual data and field information I
can recognize.
Thanks for the help. Sometimes, in an attempt to make things better, one can
just make things more complicated. Im sure ill be back with more questions
as I go along.

Hi,

The third field, combining data from two other fields is essentially a
calculated field in a table and may not be such a good idea. Why not use an
autonumber field in your authorisation table as the primary key? Something
like AuthorisationID. That way, as your users enter an authorisation number
and service code, Access automatically generates the AuthorisationID, which
you can then use in the biling and any other related tables.

Delordson Kallon
www.instantsoftwaretraining.com

I would like to have a field in one of my tables, formed from two other
fields.

[quoted text clipped - 10 lines]

donor fields exist? finally, does this post make sense? I hope I was clear
and thanks for any imput.