I am currently trying to create a table from a query but have an issue. The problem is the query is extracting data from two tables and data includes autonumber fields from the two tables. The table will not allow multiple autonumber fields. Both fields are needed but not sure how to approach the issue. I need to filter the new table on one of the two fields.
One field is the id of a company and the other is the id of an auditor. I am looking at creating a name from the auditor table then filter on it. Will take extra coding.
Anyone have another approach that would simplify the process?
Access 2010 , Windows 10, 8.1 and 7
Rod
__._,_.___
Posted by: desertscroller@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar