Combining fields to create another field

F

Faio

Is it possible to Design a table like this

Prefix, Number, Container
---------------------------
WNPL, 1929987,

Prefix, Number and Containers are fields name and so when you enter WNPL and
then 192998, the Container field will be updated to contain WNPL192998.

Can this be done?

Thanks for any assitance
 
D

Douglas J. Steele

It can't be done, nor should it. There's no legitimate reason to store the
information redundantly.

Instead, create a query that computes Container. In an empty cell in the
GUI, add something like:

Container: [Prefix] & (" " + [Number])

Use the query wherever you would otherwise have used the table.
 
L

Larry Daugherty

No, tables are just repositories of data. Besides that you should not be
mucking about massaging the data in the tables directly. That's spreadsheet
kind of behavior.

You should always design forms and use them for the entry and massaging of
data. Using a form you could have a CONTROL that will display the
concatenated data. But you should never store this data back into your
table. Re-calculate it each time you need to display it.

Read up on relational databases concepts and learn to normalize your data to
at least 3rd normal form.

HTH
 
Top