Hello,Is there a way to have two-way cross-references between entries in the same table?For example, there is a table [Companies]. Each entry, a company, can have clients and suppliers. If a company has clients, it means that those clients have at le...
Hi,I tried this approach, and unfortunately, it didn't work for me because it is not bi-directional.Specifically, when I link Company 1 and Company 2, assigning Company 2 as a client of Company 1, the record for Company 2 also should automatically in...
@Marcelo Thank you for your response. There are only two tables - [Companies] and [Contacts].However, I can't figure out how to create a relationship between two entries in the same table in the same way as it works when entries are in two separate ...
