multiple file containers per record

[beatryder]

I am currently working on a new project with filemaker, and I need some help.

I need to have the ability to store n files for one record.

In other words I need to be able to have:

Record #1: 3 related files

Record #2: 1 related files

Record #3: 7 related files

Record #4: 4 related files

Record #5: 1 related file

I have set up two tables:

And what I would like to do is set up a layout with a "drop box" of sorts for files. Essentially a container field that clears itself and moves the files into the data_files table, which will then be displayed in a portal as a list of files.

[Søren Dyhr]

I need to have the ability to store n files for one record

It has to be a related table with a foreignkey and the container field.

--sd

[beatryder]

Yeah, I got it figured out now... Thanks!