"ive tried countless ways of trying to get a new box to display the city in it, but every time i try to import the info to it, it says "this option could not be completed because the target is not part of a related table." i just need to get three boxes for city, state, and zipcode!"
Unfortunately, we don't know what "countless ways" you've tried and been unable to get to work. How is the data formatted in the Citystatezip field? Something like this? San Francisco, CA 99999
If so, you can create a calculation that extracts the city (or either of the other two parts) from this field to store in a City text field. If this is for a one time only import of data where you'll be entering new contacts directly, I'd use Replace field Contents with this expression: Trim ( Left ( YourTable::CityStateZip ; Position ( YourTable::CityStateZip ; "," ; 1 ; 1 ) - 1 ) ) to move just the City into the city text field.
- Place City and CityStateZip on the same layout.
- Choose Show All Records
- Click or tab into the City field
- Select Replace Field Contents from the Records menu, select the calculation option and enter the above calculation
- Perform the replace.
Replace field contents will modify every record in your found set. It's a safe practice to make a back up copy just before you try it out. That way you can toss your file and try again if you get unintended results.
This method assumes consistent use of a comma after the city's name. Since the original data was hand entered, it's very possible that some records have errors, such as a missing comma that will keep this method from working on every single record. You'll need to perform a find for all records where city is empty after doing the replace so that you can fix this smaller group of records manually. (To find a record with an empty field, enter = into that field while in Find Mode.)
second, is there a way to get an auto time stamp to let me know when a contact was updated? i'm seeing time stamps that i have to manually adjust, but is there one that will automatically do it?
In Manage | Database | Fields, deifne a field of type Time Stamp. Select Options and specify a Modification time stamp option for the field. Now, everytime someone edits a field in the record, the current date and time from the computer's system clock will be entered automatically into this field.