Travis

I have a contact database with multiple tables. Is it possible to search the entire database and find all of the contacts in the same city (for a mailing list)? I can't search more than one table at a time. Can I search multiple tables? Thanks

I have records with a "first name" field and a "last name" field. The problem is the "Last name" field has the whole name in it. To make matters worse some of the names are like "John H. Doe"! How can I bring the first name AND the middle initial to the "first name" field? Do I even need a script?

I need to know how to give my records in multiple tables unique ID numbers. How should I do this?

Thanks for the response. I have seperate tables because as I import tables I have different fields for the data and want to enter data as the records are imported. It seems easy for me to do it like that. But, will I have to put them all into the same table to find similar records (such as location), to create mailing lists? I also need to know how to put new ID numbers in to the records that I already have.

I have been importing records of organizations and people that is aimed to creating a contacts database. I have several tables with different kind of contacts (such as churches, schools, businesses, etc.) Some of the contacts are actual people with out an organization attached to them, and some of the contacts are just the organization without contact names attached to them. Some have addresses, phone numbers, & emails. Some contacts have all or no addresses, phone numbers, or emails attached. I can't find any field to make the primary key so I can tie up the relationships between the tables. Should I create a "contact number" to identify, if so, how do I do that now that all of the records are already imported to the database.

Thanks! Works Great.

I have filtered a table to select a certain city. Of all those records, I need to enter the county for those cities. Is there anyway i can update those records so i don't have to paste the county name over and over again? Help, Please!!!!