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
Yes. You can achieve this by using display method. Refer into this link for display method www.axaptapedia.com/Display_method
then writing display method will best suit here to build a comma separated string
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?
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.
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.
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
