New to File Maker, some questions about tables and data manipulation

[dawnd3]

Hi there, I am just learning FileMaker for a specific job I am working on. I am an Access programmer, so I understand the concepts but need to know how do some of it in FileMaker. The first task is to find out how to edit the tables. Where are the tables? Also, I want to put the name in 2 fields (FirstName, LastName) where right now it is just in one. How do I parse that apart? (It is comma delimited in the name field, last name, fist name)

Thanks for any help.

Dawn

http://www.calliopeconsulting.net

 

[NorthStarDA]

Which version of FileMaker are you learning?

For pre-7 versions of filemaker, each database is 1 table- you cannot add multiple tables to 1 database. You get to the structure of each table/database by going to Define Fields under File. For version 7, you go to Define Database under File, then you will see the different tables under the 'Tables' tab.

For the names, you create 2 calculation fields: first_name, and last_name

first_name: MiddleWords(full_name,2,1)
last_name: MiddleWords(full_name,1,1)

You can add more functions to that, as is it doesn't take into account last names with a space in them.


=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison