I have a Field which is no longer recognizing an an Foreign Key ID
this might sound crazy - am not sure what is going on. In an artwork table I enter the artist and a Title.
When I go to the invoice and the Portal I enter the artists and a list of titles come up. That is ok -BUT when I enter a new artwork with Artist and Title - The new title NEVER appears and I do not see the ID number, like I do for the older titles. Please advise - any help appreciated.