Hi Forbes and Steve,
Thank you both for your kind responses. This list is a gem. The
help and advice that can obtained is wonderful. I must confess that
when I originally tried this several years ago, I became very
frustrated and settled for flat files as I had more important things
to worry about. Now that I have more time, I have now decided to make
a serious attempt to learn FM 7 using this as a learning template
before possibly upgrading to FM 9.
Ok. What I am trying to achieve is a database(file?) from which I can
draw the following reports:
1. A basic list with names, addresses, membership type (founder,
invested, joining) and membership basis (showing
resident, non-resident and resigned) and contact information only
2. A founder members list showing the dates they resigned (If they
resigned)
3. All-Time Members List (a historical record showing joining,
investiture and resignation dates using radio buttons
in the membership type field to identify each type)
4. A separate resignation list with dates of resignations
5. Current Members List (showing member ID, first name, last name
(membership basis e.g. joining, invested and
resigned, using radio buttons in the membership basis field for
each type). There should be no resigned
members on this list.
Is the above possible? If I have one file, can you suggest what I
need to do to achieve the above objectives?
Any suggestions would be greatly appreciated.
Incidentally, I have downloaded several .pdf files from the FM site
and am thinking of buying the FM Training kit , although this is for
FM 9 rather than FM 7. Before I do so, can you advise if there is a
substantial difference between the two versions that would obviate any
learning that might make a big difference to the learning curve?
With kind regards
Roger
On Sep 3, 2008, at 6:31 PM, Robertson, Forbes wrote:
-----Original Message-----
From: FileMaker Pro Discussions [mailto:FMPRO-
[EMAIL PROTECTED]
On
Many thanks for your very prompt response. I have been playing (not
very seriously) around with FM for several years and could only create
flat files. I have now decided to try to learn much more about
relationships and this is my first attempt. As you can see, I am on a
steep learning curve.
The answers to your questions:
1. The file (database) contains the tables listed
Data entry
All-Time List of Members
Founder Members
Resignation List
Current Membership List
2. Are you suggesting that I can have one table and draw the
information for each report from that? I think that I need a deeper
tutorial on this.
Forbes' answer
Try thinking about it from the approach of what (or who) is stored in
each table. In your case the answer would be People.
In the people table you can have a field "Membership Status" which
could
contain entries like, Founder, Member, Resigned, etc
You would then do a find on the Membership Status Field, to run a
report.
Your list of tables really looks like a list of reports. For each of
these you may want a new Layout, but not a new table. Looking at the
names used by you, I think you probably only need 2 layouts, a data
entry one, and a list. The list can be used for all, founder, resigned
and current member reports. You don't need any realationships for this
(at least to get the basic functionality working.)
Another approach to thinking about do you need 1 or many tables, is to
think of the fields you would want in the tables. If you find you are
creating the same fields in several tables, it is highly likely that
you
will want this data to be in a single table not in several tables.
It may help me (and others) provide further help, if you describe what
you are trying to do. Without worrying to much about how you think it
should work as a database. My mental picture is that you have lots of
names and addresses, who are current or former members of a club (or
other organisation) and you need to be able to produce lists of
different groups of members.
--
********************************************************************************
The information in this email and any files transmitted with it is
confidential
and may be legally privileged. It is intended solely for the
addressee and
others authorised to receive it.
If you are not the intended recipient,, any disclosure, copying,
distribution or
action taken in reliance on its contents is prohibited and may be
unlawful.
Prospects Services Limited is a limited company registered in
England and Wales.
Reg No: 3042176
Registered Office: Prospects House, 19 Elmfield Road, Bromley, BR1
1LT.
If you have received this email in error please notify:
[EMAIL PROTECTED]
http://www.prospects.co.uk
This footnote also confirms that this email message has been swept
for the
presence of computer viruses
********************************************************************************
