Displayin repetitions

[Ricardo]

Hi All,

Is it possible to display repetitions of a field dependant upon a number field which would be displaying how many repetitions should be shown and then using a calculation?

I have a maximum of 12 items per job...although jobs have differnt number of items.

Each item reprasents a repetition...therfore if i have a job with 3 items i only want 3 reps if job has 12 items i want to view 12 reps.

Thanks in advance

[bruceR]

Get rid of the repeating fields and use related records.

[Ricardo]

now there is a idea!!

Can you elaborate on that?

[Razumovsky]

New Table: Items

Fields:

JobID

The rest of your item fields

Relationship

Job::JobID = Items::JobID

Portal on Job layout displaying related records from Items.