C
Curtis Stevens
I have two tables:
Customers - table has main biz information, the main table
MerchantInfo - table has a relationship to Customers using CustomerID. It
has owner's info, as there could be multiple owners per one "Customers"
record.
My question is when you run a report for example and want to embed
information into the report from the MerchantInfo table, like say DEAR
MERCHANT, etc. This works fine, but when there are multiple owners, such
there are multiple records in MerchantInfo for the same "Customers" record,
it displays only the first one. How do you display all owners on the same
report, like if you have a form that needs to be signed by both owners &
their names are embedded into the legal document?
Thanks
Curtis
Customers - table has main biz information, the main table
MerchantInfo - table has a relationship to Customers using CustomerID. It
has owner's info, as there could be multiple owners per one "Customers"
record.
My question is when you run a report for example and want to embed
information into the report from the MerchantInfo table, like say DEAR
MERCHANT, etc. This works fine, but when there are multiple owners, such
there are multiple records in MerchantInfo for the same "Customers" record,
it displays only the first one. How do you display all owners on the same
report, like if you have a form that needs to be signed by both owners &
their names are embedded into the legal document?
Thanks
Curtis