Re: Using data from Linked Tables

Hi Jeff,

Thanks for your input. It doesn't really matter about Vantage because
linked tables in Access are all the same, not updatable, right? And if you
can't update the table, you can't update the query based on the table, right?
Nor can you update a table with a relationship to the linked table, right?
If the answer to all those questions is yes, there is the dilema.

Table 1 - Linked Table Fields:
Order Num
cust Id
name
address
city
state
zip
Num Days Service Sold

So what I want to do is take the number of service days sold and keep track
of the dates of service:

Table 2 - New
Order Num
Start date
end date
Installed by
Number of days supplied
Days supplied versus days sold
total days sold per year
total days supplied per year

If everything works out, new orders will show up automatically in table 2
and I will be able to update table 2.

Let's say the Order Num field is in table 2, still don't know how to relate
these tables since once a relationship is established, it won't allow updates
in table 2.

hope that paints a clearer picture, thanks again for your input.

Mary



"Jeff Boyce" wrote:

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).








.

Relevant Pages

  • Re: Using data from Linked Tables
    ... Can you update the "query ... "Jeff Boyce" wrote: ... Num Days Service Sold ... "exported a query from Vantage and then linked it to Access". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using data from Linked Tables
    ... values if you have the raw data from which the calculations can be done. ... Num Days Service Sold ... "exported a query from Vantage and then linked it to Access". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using data from Linked Tables
    ... "Jeff Boyce" wrote: ... Num Days Service Sold ... "exported a query from Vantage and then linked it to Access". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Using data from Linked Tables
    ... "exported a query from Vantage and then linked it to Access". ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to track my inventory
    ... Qty [this is exactly how many sold for that particular transaction] ... I've got another query I'm experimenting with to just sum the Qty and then ... subtract from TotalPurchased, but it's giving me a really high number. ... Jeff Boyce 4/1/2000 12345 Elm St. ...
    (microsoft.public.access.queries)