Hi, everyone. I'm sorry if this question had been repeated but I've gone through the entire forum and couldn't find a related solution.
I have a Set which is defined as below:
Relationship
............|= Role
...................|= Party
each of them has one-to-many relationship, where
Party can be a person or and organization;
Role is the role that played by each party, eg. supplier, customer, parent organization and etc.;
Relationship is to defined the relationship between 2 parties, for instance, Mary Smith is an employee of Company ABC and the relationship between them is Employment.
Party: Party_ID | Party_Name
Role: Role_ID | Party_ID | Role_Type (Each party could play >1 roles)
Relationship: Relationship_ID | Role_ID | Relationship_Type
I have a form which defines the role and relationship with a tabbed control and it works well. The problem now is I have an embedded browse in third tab which I want to display a table like this:
From_Party_Name|From_Party_Role|To_Party_Name|To_Party_Role|Relationship
----------------------------------------------------------------------------
Mary Smith |Employee |Company ABC |Employer |Employment
John Doe |Supplier |XYZ Inc. |Organization |Suplplier Organization
My question is: how can I grab those information that are from different tables and display them correctly into the embedded browse? The primary table of the browse is "Relationship" table.
I've examined Alpha Sports and found what I want in Products Sales Review form where the primary table of the browse is "Invoice_Items" and yet it can shows the "Date" and "Sold To" fields accordingly with the "Invoice #". However, I don't find anything special that has been done to get this effect.
So, I'm wondering if my Set is incorrect? What I want is just to grab information from three different tables and display within an embedded browse.
Thank you in advance. :)
I have a Set which is defined as below:
Relationship
............|= Role
...................|= Party
each of them has one-to-many relationship, where
Party can be a person or and organization;
Role is the role that played by each party, eg. supplier, customer, parent organization and etc.;
Relationship is to defined the relationship between 2 parties, for instance, Mary Smith is an employee of Company ABC and the relationship between them is Employment.
Party: Party_ID | Party_Name
Role: Role_ID | Party_ID | Role_Type (Each party could play >1 roles)
Relationship: Relationship_ID | Role_ID | Relationship_Type
I have a form which defines the role and relationship with a tabbed control and it works well. The problem now is I have an embedded browse in third tab which I want to display a table like this:
From_Party_Name|From_Party_Role|To_Party_Name|To_Party_Role|Relationship
----------------------------------------------------------------------------
Mary Smith |Employee |Company ABC |Employer |Employment
John Doe |Supplier |XYZ Inc. |Organization |Suplplier Organization
My question is: how can I grab those information that are from different tables and display them correctly into the embedded browse? The primary table of the browse is "Relationship" table.
I've examined Alpha Sports and found what I want in Products Sales Review form where the primary table of the browse is "Invoice_Items" and yet it can shows the "Date" and "Sold To" fields accordingly with the "Invoice #". However, I don't find anything special that has been done to get this effect.
So, I'm wondering if my Set is incorrect? What I want is just to grab information from three different tables and display within an embedded browse.
Thank you in advance. :)
Comment