I want to place information on the Account Detail main screen that is tied to a custom support table. I added DISCOUNT_CODE to the Account table that ties to a Discount table that holds all the information about that discount. So the Discount table is the Parent table and the Account table is the Child table. There are many Accounts that have the same Discount code. So I made the join that way and made it a Right join type so it shows all the records from the Account (child) table, because I want to see the accounts no matter if the discount exists or not.

But when I try to add these fields to the screen, it only shows tables where Account is the Parent table. It doesn't show my new table. Can it?

If I can't do this, do I need to use some sort of function to populate the data? I have to populate four fields from that Discount table. Would I have to use GetField four times?  I'd really not have to make four trips to the database each time.

I am on Oracle 10g db and SLX 7.2 LAN.

Thank you.

I went back into the Join and changed the Visibility from Allow to Always and now I can see it. I don't know if it is going to work, yet, but I wanted to update y'all before I wasted anymore of your time.

It works if there is a Discount Code populated in the Account table and a matching record in the Discount table, but if there isn't, it gives me "You do not have access to this Account."