Hi
I am using V3.11 Build 212
I created a DVD DB that has almost 1,000 movies listed, this is my problem.
Statement listed below is after the records has been added to the table.
On the main dvd table I added a [borrow me] field then I created a custom view of the table. When someone wants to borrow a movie they click on edit = [Borrow Movie] link of the custom view then enter there name in the [borrow me] field.
Everything works fine, an email is sent to the owner of the DVD movie with the name of the movie and who wants to borrow it. The problem is when you go back to the list of movies the borrowed fielded remains blank but in the email it shows the name of the person who want to borrow movie.
I found out recently that the name of the borrower is in the main DVD table but not in the custom view.
Has anyone come across this problem? Editing data of old records does not show in the custom view table but shows the data in the main table. Security is set to only show the Main Table to Admin, so from the custom view prospective no data has been added.
Thanks
L
