Bear with me on this one ...

I'm trying to build an application that uses data held in an external application database (Agresso Business World on SQL Server).

Essentially I'm trying to build a table that has some of the fields from a table in the external database and some additional fields that don't exist in the external database.

I'd then like this 'new' table available within the new application as a data source ... sound simple ... but ...

I can easily link the table required from the external database using an ODBC connection ... no problem.

What's the best way to achieve the new data source?

I've tried creating a new table that holds the additional data and then create a query that brings the two sets of data together ... but I'm not sure how to structure the relationships etc.

I also tried creating a new table that looked up data in the external table as part of the table field definition ... that didn't work.

Is this possible?

Please note that I am fairly up to speed on Access an an application but not a VB or database development professional.

Mark M

Typically, you would define you additional fields table with the same key as the primary table to link the additional data fields to the proper row. Also if you plan on updating these fields, you should use that table as the underlaying datasource, and just display fields from your ODBC table if needed. TO show/report etc. you can create a query (view) that joins the two tables and returns all the fields.