A question about Choice and Multiple choice

Fred Hi Fred one Question.

What happen if one Staff work for 2 o 3 company. The Staff is a Freelance and work for more than a one compay.

Thanks

Fred

 I modify I place only two Staff (Rafael to Scheduler & Gabriela to Marketing)

But show both on the same Departament   I'm doing something bad.

Rafael what is your code?

FredYour code the same 

In your example Audry is on different company 

Rafael The DB is setup to only have 1 company per staff. Did you create a new dynamic multichoice field? or did you add another reference field to company?

Fred In your example Audrey is in R&D and Marketing

Rafael The code for the Staff field in Check looks for any records in Staff that have 1 of the choices selected in company. Audrey is related to Marketing only. In your first picture Marketing is selected so Audrey will show up. If you unselect Marketing Audrey will disappear.

Fred Audery appear in Marketing too if you select Marketing

And sorry Fred maybe is a Bug on Android.

Rafael You are correct. Using text() caused an incorrect valuation. Marketing is 1 and R&D is 10, so 1 is in 10 so anyone in Marketing shows up in R&D.

The correct way to do this is:

let xx := numbers(company);
select Staff where contains(xx, number(company))

It is confusing to read, but line 1 gets the value of the dmc field company in the Check table. While line 2 gets the value of the reference field company in the Staff table.

fredoThanks Fred resolved 

I return to my first question, what would it be if I had an employee in several companies. Is possible in some companys there are some company that have internal some others company and some employee work on several companys

Rafael Take a look at the code for the newDMC field. You also have to have a multiple choice field in staff.

Fred Excelent Fred. thanks.