What, if any, differences/limitations are there in having a lookup between apps as opposed to form to form inside a single app?

Curious what differences there are for some planning we are doing.

Thanks,
Brady