Display All Ph.Nos that are active

(0) Share

Report

Posted on by Sherwin

220

So I have this table employeeCompanyPhone with phone number and active checkbox. I want to display the active checked phone numbers of an employee in a field in employee master form for the respective employee. Please advise

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Sohaib Cheema 49,434 User Group Leader on at

Like (0)

Report

RE: Display All Ph.Nos that are active

It depends upon how two tables are related.

If you have a direct relationship between two tables, you can make join between two tables, to display value from other table (employeeCompanyPhone)

Another option can be writing a display method to show value in employee table.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

RE: Display All Ph.Nos that are active

You need to add this table to emp master form as a new Data source and then add new fields from this DS to master from.

Please note you should have relation between empl and employeeCompanyPhone table defined on employeeCompanyPhone.

Was this reply helpful? Yes No
Sherwin 220 on at

Like (0)

Report

RE: Display All Ph.Nos that are active

Hello Sohaib,

There is no two tables.I have a single employee master form with two tabs(Overview and company mobile info) The scenario is one employee can have 3 active or inactive mobile number and I want to show all the active phone number in a single unbound field in a form with commas.

Was this reply helpful? Yes No
Sherwin 220 on at

Like (0)

Report

RE: Display All Ph.Nos that are active

Hi,

The scenario is one employee can have 3 active or inactive mobile number and I want to show all the active phone number in a single unbound field in a form with commas. Can I show three values in a single field with commas?

Was this reply helpful? Yes No
Sohaib Cheema 49,434 User Group Leader on at

Like (0)

Report

RE: Display All Ph.Nos that are active

then writing display method will best suit here to build a comma separated string

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: Display All Ph.Nos that are active

Yes. You can achieve this by using display method. Refer into this link for display method www.axaptapedia.com/Display_method

Was this reply helpful? Yes No