Create a query with linked excel table

  • Thread starter Mauro via AccessMonster.com
  • Start date
M

Mauro via AccessMonster.com

Hi,

I have a linked excel table (updated weekly) and created a query with this
linked table and other table. Also I have created a Form based on this
query. The Form has few "tabs control". My linked table (called PO 1075-01)
has the following info:
Purchase orders
Supplier
Description
PO Ammount

And my other table (called Invoices) has a lot of columns..:
Invoice Number
Invoice Ammount
Delivery Conditions
and some others..

The problem is that when I feed the form, the data is stored in the table
called "invoices", but I'm unable to create a link between such table and
the excel linked table, in order to have "Purchase Orders" linked to
"invoices" so I can control everything by Purchase Order Number.


1.- How can I create a query that can link both tables if one of them is a
"linked table" from Excel?
2.- I tried to feed my query called "Purchase Orders Control" from the form
but was unable. (I can have several invoices from a single Purcahse Order).
3.- Any idea..?

Thanks a lot.
Mauro.
 
Top