Hello all,

I'm new to FileMaker Pro (and database design for that matter).

I'm looking to create a very simple knowledge base to use on our Intranet. Wanting to do the right thing, I was thinking of creating at least 3 files and try to normalize the data. Below are the fields created in each file.

FIle-1:

Title

Issue

Solution

Additional_Information

Document_ID

Creation_Date

Modified_Date

Product_ID

Module_ID

File-2:

Product ID

Product_Name

File-3:

Module ID

Module_Name

Now, with the following files I have created relationships between the main file (File-1) and the Product ID to the Product ID in FIle-2. The name thing for the Module ID and FIle-3.

A couple of questions.

1. Is this a smart database design? I know it's simple, but I wanted to try to normalize the data, hence File-2 and File-3. What should I do different.

2. My MAIN question, how do I then display the data in File-2 using CDML, when most of the data is coming from FIle-1. I can do this from FileMaker by just creating a field in my form, picking the file and field I want to display. I have not been able to get this working using CDML. Some of the things I've tried is:

Product Name: [FMP-Field: File-2::Product_Name]

Product Name: [FMP-Field: ::Product_Name]

How do I associate this using CDML? Any advice would be great. Sorry if there's too much or not enough detail in this post.

--

Walter

The design looks fine. Well done

To view with CDML you need to have this field on the Layout.

[FMP-Field: File-2::Product_Name] is fine if the relationship is called "File-2".

All the best.

Garry

Hi, do I understand this right?

You have products that will have a number of issues related to them, and also modules that are part of the products that will also have issues.

If so, here's a way to view the product on the web and to show all the related issues as a portal. Showing the modules on the same page would get a little more difficult as I think it might need an inline action, but I'm sure someone here has a better idea!

I hope you'll find the CDML tags useful for your own pages. Naturally, you could create and edit new issues, modules or products through your browser as well.

Put the whole test folder into the web folder of Filemaker and, on the same computer, call it as:

http://localhost/test/products/FMPro?-db=file-2&-lay=web&-format=default.htm&-View

regards, jeff

test.zip