history of records based on a three criteria in same table

[tkukulji]

Hello everyone

For several years I'm flirting with Filemaker working a small business base (since 2006.)

Currently, I'm trying to get a history of entered data in the same board according to certain criteria. I do not want to make a new table where I had to copy all the data entered so that they could see through the portal, but I want it to have a different way.

For example, I enter information such as:

1) address

2) the house number

3) name of the person from the report

4) Date of entry

5) record ID

6) categories of entry

Under the above input fields I would like to see a list of all entry based on criteria of the 1) address, 2) house number and 6) categories of entry sorted by 4) date entry or 5) record ID

Thx in front

Tonko

[dansmith65]

I'll give you a few alternative methods that might work for you:

1) If your fields are indexed, you can click on the field, select Insert menu > index.

2) Create a value list for every field "use values from field" and "include all values". Define the fields on your layout to use a drop-down list, then select the appropriate value list.

3) If you really want this data in a portal, you could use a cartesian relationship: http://help.filemaker.com/app/answers/detail/a_id/5463/~/using-the-cartesian-product-relationship-in-filemaker-pro

[comment]

Under the above input fields I would like to see a list of all entry based on criteria of the 1) address, 2) house number and 6) categories of entry sorted by 4) date entry or 5) record ID

If I understand your question correctly, you want to perform a find. You could enter the criteria into global fields and use those in a scripted find, or enter Find mode first and enter your criteria directly into the relevant fields.

[dansmith65]

And I didn't think you were wanting to perform a find. If comment or I did not answer you question, please clarify your question.

[tkukulji]

I am looking for something like a portal. I want the ability to show all the entries of the same category for a particular building in order to monitor the amount of problems that are entered under the same category. At the same time a new entry should appear on the list.

I repeat that I am not sure that the cloning of records in another table to display the same portal back to the smart solution. If no other solution then withdraw pronounced.

There is some file i put to work on it.

probe.zip

[comment]

I repeat that I am not sure that the cloning of records in another table to display the same portal back to the smart solution.

Do you mean a self-join relationship (as shown in the attached example)? There is no "cloning of records in another table" here. Data exists only in one place.

You could also do the same thing with a find, using a script trigger to refresh the find when you modify one of the criteria fields.

probeSJ.zip

[tkukulji]

I'm ashamed how easy it is. THANK YOU