Basic FK data populate on Maintenance Forms


Author
Message
Alex M. Lana
Alex M. Lana
StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)
Group: Forum Members
Posts: 20, Visits: 264
Hello Ivan,

The BOs are already configured like CRM sample app.

Our question is not how this relation works, but how to fetch data on Navigate, how to trigger the fetch of data on Navigate, as the original post.



My question is how can I fill the VendorBO "on Navigate"so the info binded to it will follow it's parent FK.

The form contains no grids. Just binded fields.

I need the form to understand the relation and fetch the FKs data on ProductBO Navigate.




And also I have lots of products without vendors, and in this case it will produce an error, because the framework tries to set an wrong equal statement (where int = string). This happens when the FK on the parent table is blank.

So our needs are:



01) Fetch child BO data from database only on parent BO navigation or

02) Avoid wrong where statements when child FK information is not present on parent BO.



Thanks,



Alex
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Also, individualy open the CustomerBO and check its ParentRelationship property.

Sorry, I meant the CustomerCreditCardsBO...

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Alex.

Have you had a look at the help file, under "Defining a Relationship Between Business Objects" ?

Also, to have a practical example, open the SampleCRMApplication, probably under C:\Program Files\MicroFour\StrataFrame\VB.NET Samples\CRMApplication, and open the CustomerMaintenance.vb, check the Customers and CustomerCreditCards BOs. Also, individualy open the CustomerBO and check its ParentRelationship property.

Let me know if you need something else.

Abraços.

 

Alex M. Lana
Alex M. Lana
StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)
Group: Forum Members
Posts: 20, Visits: 264
Greetings,

Maybe this is a simple and basic question, but as we're new to SF, here it goes.



ProdutcTable (ProductBO)

- ProdCod (PK)

- VendorCod (FK) --> VendorTable (VendorBO)



Have a Maintenance Form with ProductBO(form bind) and VendorBO,

have also a Dialog to browse Vendors binded to VendorBO.



My question is how can I fill the VendorBO "on Navigate" so the info binded to it will follow it's parent FK.

The form contains no grids. Just binded fields.

I need the form to understand the relation and fetch the FKs data on ProductBO Navigate.



Thanks,



Alex



GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search