Empty Fields Showing Up

[searson1]

OK, whilst I am here, I may as well try and push my luck a bit. I have setup a layout that will show everyones email address. However, the results also include empty fields of people who do not have email addresses. How can I achieve only showing results that actually have email addressess entered in my email fields?

Did that make sense.

[bcooney]

the easy answer is to do a find where email address is empty (just put "=" into the email address field, click Omit and do the find).

[comment]

What happened to "*"?

[searson1]

It would sure be a lot easier to understand how all these things worked if I had a database that was already done and dusted that I could take apart and see how it worked.

I have several Filemaker Pro Books, which are great for things like design, layouts etc etc etc, however, getting to grips with things like scripts and calculations does make my brain throb!!! lol. I tend to forget that not everyone has the same design and requirements as me.

Does anyone out there have a database that is concerned with church membership and stuff like that I could take a good look at? That would be cool.

I feel such a dunce when I ask what must seem to you good folks are stupid questions. Though I do appreciate the replies and help everyone has given me.

Mark

Mark

[Genx]

Well, the sample solutions (the bulk of them anyway) are generally too hard for "semi-first timers" to pull apart at first.

Start with the FM samples provided with FileMaker and work your way up -- things will make sense a lot quicker.

In terms of comment's suggestion, of using the "*", the asterix (if that is in fact how you spell it) is simply a "wild card" character and when used alone will retrieve all records that have any content in that particular field.

As usual, though i know like most people knew to FM, you might not want to read things and you want to get right on in there, you may save yourself a lot of time by reading a couple of free whitepapers (just search the forums, i forget who does them but the Novice whitepaper is good). Search the forums.

Anywho, it's hard to find specialised databases that will instantly suite your purpose, but in most cases, there are only broad categories of databases where a small bit of customization can go a long way.

Righto, any questions, just yell.

[comment]

The * symbol is called 'asterisk'. Asterix is a French comic-book character (or perhaps an attack of emotional excess in certain parts of London?).

[Genx]

Lol, awesome.