Forum Discussion
MikeTamoush
Qrew Commander
Do you have 2 tables, one called projects and one called active projects? My hunch is that you have 2 relationships, Active projects is a parent to this table, and Projects is a parent to this table.
I say that because QB defaults lookup fields with table name, then field. So I suspect Active Project - MS1 is a lookup field from a table called Active Projects. So my hunch is that you have not selected an 'Active Project' in this table. ie, the parent isn't selected.
------------------------------
Mike Tamoush
------------------------------
I say that because QB defaults lookup fields with table name, then field. So I suspect Active Project - MS1 is a lookup field from a table called Active Projects. So my hunch is that you have not selected an 'Active Project' in this table. ie, the parent isn't selected.
------------------------------
Mike Tamoush
------------------------------
MikeSanders
2 years agoQrew Member
I really appreciate your help Mike. Let me give you more details:
Table 1 - Projects, Table 2 - Tracker2, Table 3 - Pole Location
Relationship 1:
Relationship 2:
------------------------------
Mike Sanders
------------------------------
Table 1 - Projects, Table 2 - Tracker2, Table 3 - Pole Location
Relationship 1:
Relationship 2:
------------------------------
Mike Sanders
------------------------------
- MikeTamoush2 years agoQrew CommanderCheck 'Related Active Project'. Is that selected? If not, that is why your MS1 field is blank. If it is selected, be sure the MS1 field in the related Active Project is indeed filled out.
------------------------------
Mike Tamoush
------------------------------