Forum Discussion

GeorgeFong's avatar
GeorgeFong
Qrew Trainee
11 years ago

How to create a view or maybe report combine the items from 2 tables?

Hi All, I have 2 tables that have some of the same fields: - Sales (invoice #, customer name, grand total and other fields) - Services (invoice #, customer name, grand total and other fields) I...
Formulas and functions
reports and charts
Tables and fields
GeorgeFong's avatar
GeorgeFong
Qrew Trainee
11 years ago
Yes. That was considered but Sales and Services are very different. Many different fields. They start with services first then add sales. I need a way to create new table by making a VIEW or do a SQL join.