Re: Initial Caps
From: sbsmith (sbsmith55_at_hotmail.com)
Date: 03/15/04
- Next message: Winston: "Error while exporting filtered table as dbase5 file"
- Previous message: Ngan Bui: "DSN less link to SQL"
- In reply to: tina: "Re: Initial Caps"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 14:06:10 -0800
Thanks Tina
----- tina wrote: -----
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: Winston: "Error while exporting filtered table as dbase5 file"
- Previous message: Ngan Bui: "DSN less link to SQL"
- In reply to: tina: "Re: Initial Caps"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
