Related field problems [Edited]
I really need some help with this one. I have been stuck on it for days now.
I have setup part of my database as shown in the attached screenshot.
I am trying to setup two drop down lists, one for artists and one for tax. I have created two value lists of IDs, one based on the ArtworkTax TOC and one based on the AcceptedArtist TOC.
On a layout that is based on the ArtworksTOC I have created two drop down lists using the value list I created earlier. Next to the each of these drop down lists I have inserted a related field, Name from the AcceptedArtist TOC and TaxName from the ArtworkTax TOC.
Both drop down lists work fine and the related Name from AcceptedArtist TOC is showing in the edit box next to my drop down of ArtistID's. However, affter selecting a TaxID, no TaxName is appearing.
I really don't understand this as I have setup the relationships and value lists in the exact same way. I have also tried to use a different TOC of the tax table to generate the value list to no avail.
Anyone any ideas where I have gone wrong, it is probably something so simple but I'm at that point where I can't see the wood for the trees.