Portals without relationships or something similar
Allow me to explain what I'm trying to do to the best of my ability.
I work in TV production and am looking to build a database for our production trucks covering all the ins and outs. I'd like to display destinations and what is routed to them and sources and what is routed to them on one page. Correct me if I'm wrong but those 4 fields I wouldn't want to be part of one table because then they would all be related to the same X value in the table and that is incorrect. I am imagining each set of fields gets it's own table. The only way I know how to display those two in one layout is using a portal. This, however is problematic as I'm not sure of the relationship to create since they are not related from a database perspective - there is no key.