Forum Discussion
Thank you Mark. I am trying to figure out how to get a link between two tables Market Planning and Projects, the issue is that when trying to create that relationship the reference field that lines up to the key field is not avail on the drop down. I can't seem to wrap my head around how to get this to work...if those that created the tables labeled like information the same, that would probably make life easier...anyway thanks as always for being awesome
------------------------------
Michelle Craig
------------------------------
Well, keep in mind that if you were just looking for a Report Link field, you do not need to have a relationship. The report link field simply matches a field on a record in a particular table ..... think of it as a particular value in a particular field while looking at a form with that same value in any other field in any other table, or for that matter any other application.
As for the problem where different apps or different tables use different field names for the same piece of information like a project number, for example, well all you can really do is run some reports with the data and figure out which field names correspond with each other.
Legacy apps, get created over the years with different developers and those inconsistencies happen.
Who knows, maybe it takes someone like you to tackle that issue in your organization.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- MichelleCraig3 years agoQrew Member
Ok, so no matter what I do, I cannot get anything to populate for a report link...here are some screenshots. What am I doing wrong? I have been at this for far too long trying not to ask for much help, but well here I am. - the BLDG_ID and the firmpropertyidentifier are the same number, I verified this.
------------------------------
Michelle Craig
------------------------------- MarkShnier__You3 years ago
Qrew Legend
Do you have it set to display the records on the form? It doesn't look like you do.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- MichelleCraig3 years agoQrew Member
well heck - thank you!
------------------------------
Michelle Craig
------------------------------