Jump to content
Sign in to follow this  
Enuma

Repetition Fields

Recommended Posts

I would like to know if is possible to make a search upon records that have repetition fields and isolate these values upon the found set in the list mode.

I dont want to all of the repetition fields apear, only the found ones, since each one has a individual value.

Share this post


Link to post
Share on other sites

Why are you using repetitions here? You really should split these into seperate records.

Share this post


Link to post
Share on other sites

Because each record is like a report of what each actor dubed of a especified project and how much to pay him.

So i have the projects in repetition and a Sum() to do te total for me....

The problem: if its not repetition how can i do the sum over many projects as idividual records for each actor...

Thats why i would like t know if it is possible to make each individual field in te repetition apear as idividual records upon a find set.

I that know maybe theres a better solution to this...but im a newbie in FM.

Any ideas will be highly apreciated.

Share this post


Link to post
Share on other sites

Again you should have seperate records for each project.

There should be at least two tables here (3 depending on your setup such as if you have multiple actors to a project).

Actor TABLE

pkActorID

ActorFName

ActorLName

etc

Project TABLE

pkProjectID

ProjectName

fkActorID ( if only one actor to each project)

Join TABLE (if more than one actor can be on a project)

fkProjectID

fkActorID

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.