Share
ReportHello,
In this situation I have 2 tables with a relationship between them
1 is tbl_projects - in here is a lookup field (this one is called PrjStf_LU) that has a relationship to ….
2 is tbl_staff - contains stfName stfTel stfStatus stfemail and other information
I have on my app a form that is based on tbl_projects - it shows a few key bits of information regarding the status of a project. It also has 3 bits of information that ultimately come from the tbl_staff. These being stfName stfTel and stfemail
The label inside the data card for Showing the Staff Name has the ‘Text’ property set to ‘ThisItem.PrjStf_LU.stfName’. - this works
The label inside the data card for Showing the Staff Telephone has the ‘Text’ property set to ‘ThisItem.PrjStf_LU.stfTel’. - this shows nothing at all
The label inside the data card for Showing the Staff email has the ‘Text’ property set to ‘ThisItem.PrjSt_LU.stfEmail’. - this shows nothing at all
As a test i made a label outside of the form in question and set the ‘Text’ to GalleryProjects.Selected.PrjStf_LU.stfTel
(The Gallery mentioned here simply governs which project the user is dealing with)
This Approach shows the required data just fine , as does a version of the above ending .stfEmail
I am quite baffled by this and would be very grateful for any help
Surely if the form is able to show data from the far side of a relationship for one field, it can do it for the other fields too ?
James
All responses (
Answers (
432
