Need help connecting a new local table with an old table that is a SQL table

[anoble1]

I have a database i just made that has 2 linked tables. I have created a query that used both linked tables, but want to add a local table so i can add a field on my side for me to see.
My question is, how do i link my new table to the other tables? Is this possible?
Example, the 2 tables have a list of invoices. The new local table will have the "status" if the invoice is complete or not. Ideas?

thanks,

[ranman256]

If it is a local table and IN the db with sql tables, then build a query and add the table. (nothing to do)

If it is NOT in the the db w the sql tables, then either import it or Link it into your current db.

[pbaldy]

In your example, the new table would have an invoice number field in addition to the status field. The tables would be joined on the invoice number field. Warning, if the linked table is large, joining to a local table can seriously slow down queries.

[orange]

Why the local table? Wouldn't the status be something related/inherent to the tables on the "link" database?

You created a database with linked tables? Where are those tables located?

You may get some experience with database and table design by working through this tutorial from RogersAccessLibrary.

Good luck