CODEWITHSUNDEEP
filemaker
Daniel BDB
Daniel BDB

Reputation: 3

FileMaker loop the best way?

I have a Projects table and within Projects you have to choose a ProjectType. Some ProjectType are pre populated with ChargeoutHours.

When I create a Project I want to be able to select a ProjectType from the ProjectType table. However I then want the ability to be able to change the Chargeout hours without changing the original ProjectType setup.

Is the only way to do this is to create a new Project type table and use a loop to copy the ProjectType and ChargeoutHours to this new table?

Thanks

Upvotes: 0

Views: 60

Answers (2)

michael.hor257k
michael.hor257k

Reputation: 116982

When I create a Project I want to be able to select a ProjectType from the ProjectType table. However I then want the ability to be able to change the Chargeout hours without changing the original ProjectType setup.

Assuming that ChargeoutHours is eventually an attribute of a Project, you should lookup the default value from the selected ProjectType into a field in the Projects table. Then you can adjust the value for the individual project without changing the default value for the type and vice versa.

There is no need to create another table or to loop anything; all you need is a relationship between the two tables you already have (assuming you already have the two tables, Projects and ProjectTypes; your question is not entirely clear on this point).

Upvotes: 1

AndreasT
AndreasT

Reputation: 2337

Yes, you should definitely have a join table between these two tables to allow for such adjustments and to possibly also contain other data belonging to the ProjectType choice.

Depending on how this is organized, lookups or auto enter calcs are the usual practices.

Upvotes: 0

Related Questions