This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I created a simple view that returns data from 2 tables: a master table with the PK an Int, Identity Specification and the detail table with the FK an Int
The tables are Inter Joined PF to FK
When I display the view in Access it displays the data from 1 detail record for each of the linked detail records
The SQL statement appears exactly the same as the SQL resulting from an Access query linking the tables - the Acess query works correctly
SQL 2019 Express
Can you share the code of the view?
If you query the view directly from a query window in SSMS, do you get the same funky result?
The view displays correctly in SSMS but not in Access
What is incorrect in your tests?
What shall we do with an image???
That's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.
Hi @Bob Vitter
Are you having the view problem in Access?
As the experts above said, you need to provide more useful information.
Sorry for the newbie question - I only use SQLServer as a backend to Access databases
In researching answers to the questions posted I discovered that I needed to include the PK for the many-side table
With that the view works correctly in Access