concatenation

[kaosgds]

this seems really simple, and i can't figure out why it won't work. in my members table there's a field, PhoneCell. in my directory layout, i want the field to have the text "Cell: " in front of the number, so i made DPhoneCell a calculation of "Cell: " & Members::PhoneCell.

when i run the directory with data, i don't get a cell number, even if the member has one listed. where have i gone awry? perhaps it's in the relationships...i still don't seem to be getting those right.

thanks

db

GLCCtestdatabase.zip

[comment]

The expression Members::PhoneCell returns the cellphone number of the FIRST related member.

Best to define the calculation field in the Members table itself.

---

Sorry, I have just now noticed your attachment. Note that the Layout "Directory" is NOT showing records from the Directory table, and that there are 0 records in the Directory table.

[kaosgds]

so i moved things around a bit, put DPhoneCell in members like you suggested, and got rid of the directory table entirely when i realized i just needed a directory layout based on the listings table instead of an entirely new table. still, i'm not getting the cell phone field to show up. what have i missed this time?

thanks

db

GLCCtestdatabase.zip

[comment]

Auto-entry only works when a record is created, or - if "Do not replace..." is unchecked - when the field or a referenced field are modified.

Either make DPhone a straight calculation field, or re-enter the numbers to refresh the calc. Incidentally, if you're using auto enter, you don't need the extra field. You can add the auto-enter option to the PhoneCell field itself (including auto formatting of the number).

[kaosgds]

great! i've got something working now.

i remember reading somewhere in the tutorials about formatting phone numbers in fields, but i don't really remember much right now. that's mostly cosmetic anyway...as long as i've got something that works by my deadline, i can go back and make little upgrades like that when i'm not under so much pressure.

thanks so much for your help!

have a beautiful day

db