Is there a way to have a column link to another table on condition?
For example, I have two separate tables created, one for customer ‘A’ and the second for customer ‘B’… Then let’s say I have another table called "summary’ and I use column 2 to enter the customer name… Can column 3 be conditionally linked to the table belonging to the appropriate customer table as depicted in column 2?
It is not possible to have different rows to link to different tables, only different columns could link to different tables.
Is there any specific reason why do you have data for those two customers in two tables? You could also have just one table, distinguished by a “Customer” column.
Perhaps if you elaborate more what you are trying to do it will be easier to model the problem correctly.