Forum Discussion
garycarters
7 years agoHelper I
Creating relationships between two tables.
Hi I'm trying to achieve a relationship between 3 tables - customer, quote and contract. For each customer, I want to report on items from both of the two child tables. Customer is rel...
- 7 years ago
Hi,
to resolve this issue , you can copy your Quote table, stripout all columns except Quote id and description , link this table with customer table. your data model would look like this after the changes. if your table relationships looks different please share table images with related fields.
Cheers!,
ss
BobBI
7 years agoResolver III
Hi,
to resolve this issue , you can copy your Quote table, stripout all columns except Quote id and description , link this table with customer table. your data model would look like this after the changes. if your table relationships looks different please share table images with related fields.
Cheers!,
ss
- garycarters7 years agoHelper I
I'll give it a try.