Relacionamento Muitos-para-muitos


Author
Message
Malcon M. Mikami
Malcon M. Mikami
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
Bom dia, fiz uma aplicaçao de teste para ver o relacionamento multiplo.

Possuo 3 tabelas  Fornecedor, FornecedorProduto, Produto.

Quando faço o relacionamento 1..*(Match) entre FornecedorProduto - Produto ele retorna a linha selecionada.

Quando faço *..* (Cascate) entre FornecedorProduto - Produto ele nao retorna nada. Oque pode ser?

Nas imagens, o sistema com o relacionamentos e os resultados.

Attachments
match.JPG (191 views, 215.00 KB)
cascate.JPG (188 views, 225.00 KB)
Replies
Malcon M. Mikami
Malcon M. Mikami
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
Hi Trent, thanks for the prompt reply.
I have the following situation:
 
Person (PrimaryBO)
PrimaryKey  Name
1         Malcon
2         Trent
3         Ivan
 
 
PersonProduct(RelationBO)
PersonForeingKey     ProductForengKey
1                           1
1                           2
2                           1
2                           3
2                           4
3                           1
 
 
Product(ChildBO)
PrimaryKey    Details
1                Hard-Disk
2                CPU
3                LCD
4                Case
 
 
When I select a line of Person, it will filter every record in PersonProduct, I would like to automatically filter out all visible record in Products based on PersonProduts
 
My relationship this way:
Person ---(MatchCurrentRow)----PersonProduct ----(CascadeRowFilter)----Product
 
In short, when I filter a Person would like to see all the details of the products this person.

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
Malcon, have a look at the BusinessLayerLinkManager.

Here you find a post about it: http://forum.strataframe.net/FindPost6626.aspx

Do a search on the forum and you will find much information on how to use it.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Keith Chisarik - 17 Years Ago
Ivan George Borges - 17 Years Ago
Dustin Taylor - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Trent L. Taylor - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago
Malcon M. Mikami - 17 Years Ago
Ivan George Borges - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search