I have a simple dataverse table (tbl_Vendor) withs vendor information.
I have a screen that has:
- A galley form (galVendor) for vendor selection
- A Vendor Info display form (dispVendor)
I recently added another table (tbl_Comment) to hold comments concerning the vendors in tbl_Vendor.
This table (tbl_Comment) has a relationship with the vendor table (tbl_Vendor) through the addition of a lookup column (lu_Vendor) in the Comment table that allows you to select a vendor record.
I want to add a new form (frmComment) to the screen, that will display any existing comment for the vendor selected in the gallery. But I cannot figure out how to setup the form (frmComment) to display all comments for that selected vendor.
