Re: Initial Caps
From: tina (noaddress_at_spam.com)
Date: 03/13/04
- Next message: Douglas J. Steele: "Re: import text w/ 255+ fields... changing field names?"
- Previous message: Steve: "Re: Importing text files"
- In reply to: sbsmith: "Initial Caps"
- Next in thread: sbsmith: "Re: Initial Caps"
- Reply: sbsmith: "Re: Initial Caps"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 13 Mar 2004 10:42:19 GMT
my guess is that the db has a separate table with company name and other
info, and the "number" you're seeing in the export is the company table's
primary key (as a foreign key in the general table).
you need to identify the source of the company name that you're used to
seeing in the database. suggest you check the Relationships window to see if
a relationship is defined on that "number" field. or you can check any form
that has a combo box that lists the company name, to see what table is used
in the combo box's record source.
once you identify the table that holds the company names, create a query,
and link the general table and company table on the company table's primary
key field and the general table's "company" (number) field. then select the
fields you want to export, including the actual company name from the linked
table. you can then export the query object.
hth
"sbsmith" <sbsmith55@hotmail.com> wrote in message
news:8F840F34-A08B-4AF9-BB0E-509680F93112@microsoft.com...
> When I export data from a database, the company field exports a number not
the actual data. Is there a way to get the data to export correctly? The
company & location fields are linked to the general table. Thanks
- Next message: Douglas J. Steele: "Re: import text w/ 255+ fields... changing field names?"
- Previous message: Steve: "Re: Importing text files"
- In reply to: sbsmith: "Initial Caps"
- Next in thread: sbsmith: "Re: Initial Caps"
- Reply: sbsmith: "Re: Initial Caps"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
