Hi All,

I have a form with some fields including address fields.  There is one field FormattedAddress which I have to update with some fields concatenated for an address label.

What would be the best way to address this kind of situation?

So far I am testing in the BO_FieldPropertyChanged event, but I then have to filter this event for the list of fields that will participate in the concatenation format.  Just wondering if I am in the correct place or there is any other way to do this?

Thanks!

Edhy Rijo

I tend to agree with Peters assessment of not storing it in the database.  I am sure that you have your reasons but creating a property to do the work for you when you need it would be more efficient and would normalize your data. 

I am sure that you already know this, but an Or in VB.NET is BitWise and an OrElse is an explicit test.  Same is true for And...you would use AndAlso in its place.  Your code will work in this scenario since this is an enum, but in other scenarios this may fail.  Another option is using a Select:

Peter, Trent,

I understand what you guys are saying about using a Custom Field, and I will do it that way, but this is a learning experience for me.  I am in the process of learning and getting comfortable with VB.NET in order to move on into the .NET league .

I tested it with a Select Case and it is working fine, thanks again for the push

Trent and all, I am an experienced VFP developer (20+ years), but I can not say the same for .NET and my choice language VB.NET, so please feel free to correct me, suggest, encourage and anything else necessary to help me out in this learning process at any time.

Once again, thank you both!

Edhy Rijo