I'm trying to get a total from our bank adjustment entry form per project and punch it into our project entry screen to run a project cost analysis. I'm having trouble linking the "BankTran.Character01" (this is where we are typing in the project #) field to the project entry form so I can access the data from the banktran. I've been trying to get this to work through the Data Tools and it's been giving me some trouble.
So I try to do a like field and its going
View name: BankTran
Parent: Project
View type: Foreign Key View
Column Name: ProjectID
Like Column: BankTran.Character01 (this field ends up changing back to Project.ProjectID after i click off of it.)
Adapter Name: BankAdjEntryAdapater
I added BankAdjEntryAdapter through assembly reference manager thinking that was the issue but I'm getting the same results.
This is the first time I've actually tried to use Data tools and i'm at a loss. What steps am I missing or is this even the right way to go about it?
So I try to do a like field and its going
View name: BankTran
Parent: Project
View type: Foreign Key View
Column Name: ProjectID
Like Column: BankTran.Character01 (this field ends up changing back to Project.ProjectID after i click off of it.)
Adapter Name: BankAdjEntryAdapater
I added BankAdjEntryAdapter through assembly reference manager thinking that was the issue but I'm getting the same results.
This is the first time I've actually tried to use Data tools and i'm at a loss. What steps am I missing or is this even the right way to go about it?