weezy

Thanks! That fixed it... the proper() function that is.

Every time I export text to a csv file some of the text fields appear in all CAPS - I need them in titlecase. In the database they are appear to be correct - I've gone to the trouble of fixing each field with the TextStyleAdd() function. When the records are imported into the database they are all in CAPS, then changed via the TextStyleAdd() of TextStyleRemove(). Why doesn't it preserve the formatting on the export? Any ideas?

There are only two tables involved. Table1 contains two fields called city and state. These values are combined via a calculation in a field called city_state. The city_state in table 1 has a lookup based on one of table2's fields, city_state. The layout for table1 contains a portal to table2, which displays any records that match the city_state field in table1. I want to create a new record, in the portal/table2, that inserts the city, state, and city_state fields from table1 and creates a new record in table2 based on that information. When I try to enter something in the new record I get an error saying, "this field is not modifiable.' I can get it to work if I change the relationship between table1 and table2 to ref. the city fields in each table. The problem with doing this is the table2 portal won't show any existing related records. I have a feeling that the lookup or possibly the calculation fields are screwing it up somehow. ??

Might as well put it up front, I'm a rank amateur. Sorry if this question has already been asked. I've created a portal that displays related records from a table. Although I have changed the relationship to allow 'creation of related records' it still isn't letting me create them. A row is generated, but I can't enter data in it. I want to be able to enter the first field in the portal record, put in a piece of data (one letter), and have it insert data from the related table across the portal record. Can anyone point me in the right direction? I don't want to mess around with creating buttons and global keys etc. I'd rather fix it in the relationships/tables if at all possible. Any help is much appreciated, Louise