Forum Discussion

Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
8 years ago

add record in child table in different application with reference to parent

There is most probably already a sollution described for my problem i just don't know exactly how to describe it so looking for the sollutinion is not easy either. Here we go.... I have a table ...
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

Hi,

Would it help to pass the summary field, [# of Milestones] from the Projects table to the Activities table as a lookup field? Likewise, you could pass the summary field, [# of Activities] from the Projects table to the Milestones table as a lookup field as well.

This way you have an indirect reference to the Milestones records that have Projects in common with Activities, and also, you will have a reference to the Activities records that have Projects in common with Milestones.

Make sense?