Re: Using data from Linked Tables
- From: Mary <Mary@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 1 May 2007 05:44:00 -0700
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: Jeff Boyce
- Re: Using data from Linked Tables
- References:
- Re: Using data from Linked Tables
- From: Jeff Boyce
- Re: Using data from Linked Tables
- Prev by Date: Re: feeding from another database
- Next by Date: Re: Using data from Linked Tables
- Previous by thread: Re: Using data from Linked Tables
- Next by thread: Re: Using data from Linked Tables
- Index(es):
Relevant Pages
|
