Ben,
I do not understand what you mean by more than one listing per address? A
shipment should have only one address, e.g. destination.
Also try to set the make table query to unique records only in the
properties. This works if you are getting the same record repeated.
Otherwise this sounds like a join problem. View the query in SQL view and
post the SQL so we can look at it and this may help us decipher your
problem.
Thanks
Hal
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
"Ben Norman"
<[EMAIL PROTECTED]
.com> To
Sent by: [email protected]
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] (Attn: Hal) Re:
06/14/2005 11:58 ODBC and AS400 Database
AM
Please respond to
AccessDevelopers@
yahoogroups.com
I currently have two tables in my database, one is the ODBC link to
the AS400 table and the other I populate with PRO numbers given to us
by Yellow freight. What my goal is supposed to be is that I assign a
PRO number to each shipment automatically through the database, and
the end results is a 4X6 shipping label with the name and address and
a PRO number. The problem is that the database has more than one
listing per address, so when I assign PRO numbers automatically it
duplicates them when I run a MAKE TABLE QUERY.
--- In [email protected], [EMAIL PROTECTED] wrote:
> Ben,
> Assuming your users won't be confused by the fact that the
changes they
> make do not show up on the AS/400, I would suggest the following:
>
> Use a Make Table query to make your initial table. However, Access
will
> inherit the field properties from the AS/400 and sometimes this can
lead to
> unexpected results.
> Check the properties and be sure you are ok with them.
>
> If not, I use Append queries to get the data from the AS/400 into a
local
> table. Delete queries to clear the local table. This allows me
better
> control of the table.
>
> I have many databases where I download the data from our AS/400
using Task
> Scheduler and macros. The user gets only the data I download.
> Also if you are working with very large amounts of data, you should
be sure
> at a minimum to Compact and Close on a regular basis.
>
> Good Luck
> Hal
>
> Hal McGee
> Engineering Data Manager
> Group Engineering - Process and Compliance
> Seating Products Group
> B/E Aerospace
> Winston-Salem, NC
>
>
>
> "Ben
Norman"
>
<[EMAIL PROTECTED]
> .com>
To
> Sent by:
[email protected]
>
AccessDevelopers@ cc
>
yahoogroups.com
>
Subject
> [AccessDevelopers] ODBC and
AS400
> 06/11/2005 08:21
Database
>
AM
>
>
> Please respond
to
>
AccessDevelopers@
>
yahoogroups.com
>
>
>
>
>
>
> I have a database that pulls all info from an AS400 table via ODBC,
but
> the AS400 table is read only. I want to be able to add info to the
> records, but not have to touch the AS400 table. Is there a simple
way
> to create a second table mirroring the AS400 table, and be able to
> populate it automatically with the AS400 info?
>
> I need it to be searchable from a report as well.
>
> Thank you all.
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
> Yahoo! Groups Links
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AccessDevelopers/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
