With your limited description of your database its a little hard to give a calculation. You only seem to mention 2 tables.
What does ...if the address is related to Clients 2 mean"? You mean 'equals'?
Inbed a calculation where?
Do you mean, If the address on Table 1 equals the address from Table 2, use the address from table 2, but if the address is equal to the address in table 3, use the address from table 3? If so, then this may indicate something wrong with your basic structure.
If these tables are related, when you create a related record from the appropriate table, the address should/could automatically be populated
The Three Tables are Address, Client and Gallery. They are related.
When I bring up the address in a drop down box it will also bring in the client, the client and address shows, BUT if there is no client, only the address will come up. I would like it to then look at the Gallery table as the Gallery has a related address in the address table.
I do not know how to write up the IF statement. I have attached the related tables.
Thank you for your help. Greatly appreciated. If there is also a good tutorial on it, I would gladly check it out.
Any help on this would be great.
A description of HOW your tables are related would be helpful.
Then please describe on which of these tables your layout is based.
It is in the Artwork_Table, location portal
But none of the table occurrences in your last post are called "Artwork_Table". None are called "Location". So my understanding of the context in which you want this to work is still incomplete.
I found a solution - after a ton of attempts: If(Client_FK_ID ≥ 1; Clients 5::C_FullName & ¶ & C_Address; If(Gallery_FK_ID ≥ 1; Gallery 9::Gallery & ¶ & C_Address))
I appreciate all the help offered.