Hi,
I want to make a simple list, can be a query or a report, to just show some records. The problem is that I have fields in different tables, and they should be treated as equals.
Like this:
Fields:
Table Clients
Name
Date of Bithday
Phone Number
Table Drivers
Name
Date of Birthday
The report or query should show a simple list
Name | Date of Birthday | Phone
In one query I didn't manage to do it, since it will try to make Name of Drivers linked to Name of Client. Which is linked, but as I said, should be single list.
So I did 2 queries. One for Clients and one for Drivers. Then I tried to list all records on a report, but the report wizard didn't accept data from more than one query.
Anyway to solve this? Maybe transfer the queries list to a table? But in an automatic way, since the query is updated every month.