help this not answered previously

[clemzzz]

posted December 07, 2001 01:45 AM

------------------------------------------------------------------------

[Mr.Morning]

I am a little confused by your question. I don't completely understand your situation but I think if you create a column/list report in new Layout and just specify what you want for your headers it basically should work. The key is making sure that all your items that you want as headers are under one field. If you don't want certain ones to appear then just eliminate them through either a find script and just a manual find.

[Garry Claridge]

You could have a calculated field for each item in the value list. Then use these fields for the report/layout. The calculation could check on the contents of the real data field.

Hope this helps.

Garry

[clemzzz]

Thanks but i'm not clear how to use the calculators for this one

I have read the manual but not clear.

I realise i must have a date stamp for when the field is modified

that is the field with the value list , because i want date information in the report.

Maybe i'll explain more

it is a contacts database ,contact name will be field A

the contacts are contacted etc.. at certain times

the method of contact is the field we'll call B ( value list )

date field B modified will be field C

how can i do this i need more info on calculation field.

so report should have field A as column 1

value list x10 items headings for other columns

date ( field c) put under appropriate heading from value list .

so if field B was set to "telephoned" date c would be entered into the column heading "telephoned"

I'm baffled and very new user

give me a hint or 2 please please

[tlsparker]

I would consider data entry and data display (reporting) separately.

First, enter data in three fields: Company, contact method, and contact date. Each contact event is a separate record. You will also need a unique identifier field for each record, ideally an auto-enter serial number of some type.

Display in the reporting style you desire using separate relationships for each field value you might encounter in the contact method field.

To do this, you may want to try the crosstabs method. I find it easier to understand database design if I am looking at a working example. You can download my Crosstabs example at www.tgparker.com/filemaker or send me an email and I'll send it to you.

Tom Parker

[email protected]