I have 2 Notes forms:
Form A contains: Employee Name, Job ID, Other Info...
Form B contains: Job ID, Job Name.
Now I want to create a form C which contains Employee Name, Job Name. When user creates new document from this form, and input there Employee Name => I want to get the Job Name where FormA.Job ID=FormB.Job ID. Please help me on how I can do this. It looks like that we bring relational database into Notes.