-----Original Message----- From: FileMaker Pro Discussions [mailto:[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 ********************************************************************************
