If you open Manage | database | fields, you can find and double click the field definition for the phone number field and that will open the field options dialog box. Click the validation tab and you'll find a box you can select to specify unique values.
But this may not be practical. Experience with a contact manager I created here where I work reveals that duplicate phone numbers happen quite easily. Customer one abandons a phone number and does not notify us that they have done so. Then customer two gets a new phone number and it's the number customer 1 abandoned.
This happens less frequently now that we can take cell phone numbers from old phone to new phone but it still happens.
Your second question refers to what we call a conditional value list.
Here are some links on the subject:
There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in FileMaker 12.
The last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Hierarchical Conditional Value lists: Conditional Value List Question
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Thanks for the help!!
I have some additional questions.
- Would you happen to have any links to tutorials about setting up layouts?
- Is there a way to create a sort of sub table that links to a main table? What I am looking to do is create a 'notes' subsection that can be edited each time an interaction occurs.
- If there is a way to create a subtable, is there a way to create a counter on the layout side of things that will count the number of 'notes' (which in effect would give you the number of interactions you have had with that customer)?
- Do these forums have a way for users to reach out to people that develop DB's for possible paid projects?
My ultimate goal with this is to create a type of customer database for my wife (she is a hair stylist) that she can use to keep track of her customers. So far I have found no template that works for me and when I tried to use the tabbed browsing thing it ended up being a disaster. I like that FMP is cross platform, but it may not be in my best interest to go with it if I cannot get this done within a reasonable time.
Is there a way to create a sort of sub table that links to a main table?
Look up "Portal" in FileMaker help or any training materials you might have. This is a very commonly used layout object for setting up what is usually a kind of "mini table" of related records such as the notes you describe.
is there a way to create a counter on the layout side of things that will count the number of 'notes'
Yes, it's a function called "count" that you can also look up in help.
Do these forums have a way for users to reach out to people that develop DB's for possible paid projects?
There's a "consultant" link at the top of this page. In addition, if you like the advice you are getting from someone, you can click their icon to the left of their message to get a screen where you can send them a private message.