Hello; I am working several days but I can´t found my mistake. Please help me!
I have 3 tables
TABLE1 AUTHOR
IdAuthor
Author
TABLE2 COLLABORATOR
IdCollaborator
Link_IdAuthor ---------- Master Table1.IdAuthor, chose manually. It is ok
Collaborator
TABLE3 BOOK
IdBook
Link_IdAuthor ----------- Master Table1.IdAuthor, it is load automatically
Collaborator . . . . . . . DropDependent on Link_IdAuthor It doesn´t work fine!
When I Add a BOOK record in table 3, I need see only the Author´s Collaborators, not all.
I test it in the dropdown Lookup wizard and works fine, but it doesn´t work in the application.
The wizard is configured in the TABLE3.Collaborator like:
Table TABLE2 COLLABORATOR Table from chose the Collaborator
link field IdCollaborator
Display field Collaborator
Order ....
This dropdown is dependent on ... It filter only the author´s collaborators.
Category control table3.Link_IdAuthor
Category field table2.Link_IdAuthor
It looks like that the Link_IdAuthor is empty until the end of the process. Is it true?
If I chose the Link_IdAuthor manually, all works fine, but I need that it works automatically
What am I doing wrong? Is it possible? How can I do?
Please I need to solved it.
Thanks in advance
