Access to a column in one of my 2 databases based on a previous value

[Clementkilkenn5]

Hello everyone,

I have a project management app. And I would like in this database to assign a company present in either the Visitors or Workers database. The Application must also take into account that it must search in the companies of the right database in connection with the choice to the previous question Workers or Visitors.

I'd like to get closer to a ref system, because if the company isn't present, I'd like to be able to add it to one of the two databases.

Thank you in advance.

Don't hesitate to ask me questions if you need more information.

[Rafael_ANEIC-PY · Accepted solution]

Hello there,

Do you have a separate table only for companies?

I would guess if you had one, then you would have a reference to this "companies" table from both the "visitors" and the "workers" databases.

But if you don't have that "companies" table, the situation is quite different, if that's the case you're gonna need 2 REF columns, one to the "Visitors" table and the other to the "Workers" table, and then hide one and show the other depending on that "previous choice" question you talked about.

Can you expand a bit more on what you call a "company" and if you do have a table for it?