Re: Using data from Linked Tables
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Tue, 1 May 2007 08:04:29 -0700
Mary
I'm not familiar with that software, so I'm not following what you mean by
"exported a query from Vantage and then linked it to Access".
Does this mean?:
* your data is in a single table in Vantage
* you created a query in Vantage
* you created a datafile (but not in Vantage ... where is it?) containing
the data your query returns
* you linked to that datafile
Is the table in Vantage updatable (i.e., add/edit/delete data)? Is the
query in Vantage updatable? Is the datafile updatable?
When you say "make a second table with the data I need to keep track of", do
you mean in Vantage? In Access? What "data ... keep track of"? Can you
provide an example? How does this data relate to the data in your query
from Vantage? Do the two have any common elements/fields?
Based on your description (table1 - customer order/# of service days; table
2 - dates service provided), I don't see any common field (e.g., CustomerID,
OrderID, ...). I suppose you could count the rows in table2 and see if that
number matched the total # of service days in table1 ...
I still don't have a very clear picture of what you have, what you've done,
or what you are trying to accomplish. Could you state what you will be able
to do (i.e., prepare a report showing X, Y, Z) if everything works out?
Focus less on the HOW (table, query, link, ...) and more on the WHAT. I'm
not asking out of curiosity, but because the folks here in the newsgroups
may be able to offer alternate approaches if we knew where you were going.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Mary" <Mary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0E044B74-3DDE-46DE-A61C-181626C1BA0B@xxxxxxxxxxxxxxxx
Hi Jeff,
Thanks for your reply. Maybe I am making a wrong assumption. Our
company
software is Vantage. I have exported a query from Vantage and then linked
it
to Access. I cannot update the existing data in that linked table. And,
as
far as I know, I cannot add fields to that table either. So, I thought I
would make a second table with the data I need to keep track of. I
somehow
need to link the two tables. If i establish a relationship, it won't let
me
update the second table.
For example, the first table has the customer order and number of service
days sold. In the second table I need to keep track of the dates we
provided service. I want new orders to automatically appear on the second
table.
I hope that helps explain further. I look forward to your reply.
Mary
Mary
I'm having trouble visualizing how you are trying to do something...
(that
I'm also having trouble visualizing!)...
You have a table that is not updatable, but you want to update it via
another table?
WHY? Please describe what you want to accomplish ... there may be a way
to
do it that doesn't use the approach you described.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Mary" <Mary@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D3287D36-17CB-443C-B9AD-3281EAD8FCF5@xxxxxxxxxxxxxxxx
I have a linked table. Is there a way to link that table with a table
that
can be updated?
In other words: i want to use all the data in tblLinked (cannot be
updated)
in tblNewInformation (can be updated).
.
- Follow-Ups:
- Re: Using data from Linked Tables
- From: Mary
- Re: Using data from Linked Tables
- References:
- Re: Using data from Linked Tables
- From: Jeff Boyce
- Re: Using data from Linked Tables
- From: Mary
- Re: Using data from Linked Tables
- Prev by Date: Re: i forgot my password in access how i get it is there any master p
- Next by Date: Re: Need advice on table structure
- Previous by thread: Re: Using data from Linked Tables
- Next by thread: Re: Using data from Linked Tables
- Index(es):
Relevant Pages
|
Loading
