Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No problem,
The Key field to the Clients table is [Record ID#]. When you built the relationship Quick Base was trying to be helpful and it created a new field called [Related Client]. That would be OK if you wanted to to manually link up each Scheduled Ad record.
But what we really need on the right side of that Relationship is the [Record ID#] of the client record.
So, .. just delete that relationship as you have very little invested in it in terms of lookup or Summary fields and create a New relationship, but this time for the right hand side field which is he "reference" field for the Relationship don't let Quick Base create a field for you, but rather select the field [QB#] as the reference field.
You should also delete the field [Related Client] as it will not be needed and will just be confusing. When you delete the Relationship, Quick Base will ask if you want to delete that field.
The Key field to the Clients table is [Record ID#]. When you built the relationship Quick Base was trying to be helpful and it created a new field called [Related Client]. That would be OK if you wanted to to manually link up each Scheduled Ad record.
But what we really need on the right side of that Relationship is the [Record ID#] of the client record.
So, .. just delete that relationship as you have very little invested in it in terms of lookup or Summary fields and create a New relationship, but this time for the right hand side field which is he "reference" field for the Relationship don't let Quick Base create a field for you, but rather select the field [QB#] as the reference field.
You should also delete the field [Related Client] as it will not be needed and will just be confusing. When you delete the Relationship, Quick Base will ask if you want to delete that field.