Joining 2 fields?

[NewShoes]

Hey all,

Not sure this can be done but I have 3 fields in a table. Forename, Surname and Full Name. If possible I would like Full Name to automatically populated from the other 2 fields. However, and here is the problem....I don't want to do this in a query but just just in the table it self (if that makes sense)?

thanks,
-NS

 

[DCrake]

Why do dyou not want to use a query? A query is just another way of displaying a table. You should not let users view tables directly anyway.

 

[NewShoes]

I just didn't want to use a query as these fields will be used in a subform that will be used to create/delete records. I understand that inputting/deleting from a query can sometimes be difficult?

 

[Galaxiom]

Including a Fullname field in the table is a breach of normalization.

No problem working with ordinary queries as record sources. Aggregate queries and certain joins are not updateable but using a query as a record source is standard practice.

However I would not create the FullName in a query but rather use a control on the form to concatenate the Forename and Surname. This uses less memory.

ControlSource property:
= [Forename] & " " & [Surname]

This control will not be editable which is what you would want. Any changes made in the Forename or Surname controls will automatically be reflected in the Fullname control value.

 

[NewShoes]

Including a Fullname field in the table is a breach of normalization.

No problem working with ordinary queries as record sources. Aggregate queries and certain joins are not updateable but using a query as a record source is standard practice.

However I would not create the FullName in a query but rather use a control on the form to concatenate the Forename and Surname. This uses less memory.

ControlSource property:
= [Forename] & " " & [Surname]

This control will not be editable which is what you would want. Any changes made in the Forename or Surname controls will automatically be reflected in the Fullname control value.

Many thanks for this. I will give this a try tomorrow