XJoe

One way is to turn on "Allow editing of value list" then your users can add to the value list. Then you can turn on "Auto-complete using value list" I think that's the only way auto-complete works, you have to add it to the value list first.

I too trying to make a xsl style sheets so I can import an XML from an http request. I have no ideal how to do this. Is there an easy to understand guide Anybody can get me started in the right direction. This is what I need to convert. <?xml version="1.0" encoding="UTF-8" ?> - 2010-06-15 19:37:28 - - 2010-06-15 19:39:32 Thanks

I've read many post and can't get it to parse data from all three rowset. I need the row name, characterID, corporationName, and corporationID from each rowset. How do I make it go to the next rowset so I can get the data. This is the first time I've tried to parse. <?xml version="1.0" encoding="UTF-8" ?> - 2010-06-15 19:37:28 - - 2010-06-15 19:39:32 Thanks for any help

Got it worked out.

Is it possible to base a relationship from portal to portal? Let me try to explain. Layout from table "Items" Lets say Item name is "Bluetree". Its a tier 4 Item. Tier levels are from 1 -4. It takes 2 or 3 tier 3 items to build a tier 4 items. It takes 2 or 3 tier 2 items to build a tier 3 items. It takes 2 tier 1 item to build a Tier 2 items. What I would like to do is on the layout. Portal 1 shows the tier 3 items I need to build a bluetree. (This I can do. The rest I can't) Portal 2 would list the items you need to build the tier 2 items from portal 1. Portal 3 would list the items you need to build the tier 1 items from portal 2. Hope this is clear what I'm trying to do. Thanks

Hello, Is there anyway of importing all the tables and data from an ODBC source. The database has lots of tables (like 70 I think). Most of the tables have 100 of thousand of records. Would love to convert it to an FMP file. Thanks

I'm using the city as a drop down list and then a drop down of all states with the city name. Works great for what I'm doing. I just want an more up to date before I release my run time.

Just use a if then test to see if the field is empty or not. If it's empty the copy the field, and if not empty then don't copy the field. Hope this helps

I too am in need of an up to date zip code list. Looking forward to your conversion. Thanks in advance.

OK, got it. Thanks

Hello I have a scrip trigger to go to a field onobjectexit. But when I tab out of it goes to the first field on the layout not the field in the scrip. Anybody know what I'm doing wrong. Thanks

If I could ask one thing more. The other fields that have the city and state names have in the format 'VT' and 'Bourbon' How can I remove the ' ' and just leave the city name. I tried Filter ( City ; "abcdefghijklmnopqrstuvwxyz" ) It took out the ' out and also took out the first letter of the name. thanks I see I had to include the caps for each letter. Got it, Thanks

Worked great, thanks you two

Hello all, I have a field I imported from a SQL file. In each record it has text and a 5 digit number. INSERT INTO `zipcode` VALUES('00401' I would like to remove everything except the numbers. I have 42000 records. Anybody got any thoughts how this may be done. Thanks