Quick question! (sort of)

I have a layout that needs to contain word documents and pdf's from clients... creating some containers and putting in each file would work, but there are too many files for some clients (some clients have close to 100 documents)! I guess I need a way to store multiple docs in one container or create containers dynamically... Or perhaps there is something else I could do. Any suggestions??

Heres what I want:

1) EASY access to many word docs and pdfs from filemaker...

2) to log all changes and created documents (via scripting?? etc)...

Thanks!

-Chris

A container can contain only one document... to get "unlimited" container fields, use a related table to hold the documents. Each record has a container field, create a new record for each document. Display the related records in a portal.

Chris,

Quick Answer! (sort of)

Create a new table with each record having one container field and one Customer_ID field.

Relate the table to your existing table on customer_id = cusromer_id.

Create a new record in this new table for each document.

You will then be able to display all of the records for any given customer by creating a portal in your main file.

With regards to the

"2) to log all changes and created documents (via scripting?? etc)..."

....bit vague that I am afraid. Thats a bit like saying 'I want a system that does something....to something' so sorry can't help you with that one

HTH

Phil

Sorry to repeat Vaughan's advice but his got posted while mine was being typed

Edited June 25, 200718 yr by Guest

I can't believe I didn't think of that!

Thanks for the slap in the face... i needed a wake-up :

-Chris

Yeah... for me, I knew I had a handle on the relational stuff when I realised that "tables->records" are the same as "records->fields" just on a different level of existence.

Thus, every time I thought I had a situation where I needed multiple fields to solve a problem, I knew that with a change in perspective the problem sould be solved relationally with related records. Ditto for situations where a problem seemed to require the creation of multiple tables.

Is there a way to make a container that holds a word document actually display that document in an editable way? Is there a plugin that does this? I haven't been able to find one :o

Chris,

check out the Web Viewer