Formula/Relationships
I have 2 tables I am trying to cross reference. Table 1 - Accounts - lets say this table has account names and dates the request was submitted Table 2 - End of Day Report - This report has the ac...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you tell us if in table 1 the Account name is unique? Or are there duplicates there?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
There may be duplicates
------------------------------
Samantha Stanley
------------------------------
------------------------------
Samantha Stanley
------------------------------
- MarkShnier__YouHmmm,
If you were wanting to link these up manually and you had infinite manpower or infinite woman power (which is probably 2x infinite, how would you match them up?)
Would you be OK to simply make a report link field so that when you viewed a single record in table 1 it would show a embedded report of all the matching records in table 2? If you want that then it is easy.
Just make a formula field on table 1 which would concatenate the account name and the date field together and then make a similar field on table 2. Then set up a report Link field on table 1 and match up those two fields Field Properties configuration and then put that new field on the form and set the form properties to display those records directly on the form.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
