OK .... THERE IS A TERRIBLE PROBLEM. PERHAPS IT'S A BUG IN ACCESS 2007.
I spent some time trying to get my data back after destroying and
re-establishing relationships ... Everything I've done is in futility
because I either lose the information .... cause an error ... or get stupid
freakin' BOUND VALUES again.
HERE is what I'm trying to do.
************************
I have these tables:
BANK INFORMATION ---- Primary Key ID, Column -- BANK
ACCOUNT INFORMATION -- Primary Key ACCOUNT NICNKNAME, Column -- BANK
I have this FORM:
ENTER ACCOUNT INFORMATION
I have this relationship:
[BANK INFORMATION].ID is a ONE to MANY relationship with [ACCOUNT
INFORMATION].BANK
On the Form I want the user to have the opportunity to select from ALL
available BANKS.
When I use this query:
SELECT [BANK INFORMATION].ID, [BANK INFORMATION].BANK FROM [BANK
INFORMATION]
The user gets the opportunity to enter the bank of their
choice but the table displays a numerical value rather than a Bank value.
If I use the query: SELECT [BANK INFORMATION].BANK FROM [BANK
INFORMATION] The FORM shows a bunch of empty blanks.
"Rick Brandt" wrote:
[Quoted Text] > "Confused Report maker" <Confused Report maker[ at ]discussions.microsoft.com> wrote
> in message news:D38216D0-B565-41EB-AD52-7CD4D29AB19E[ at ]microsoft.com...
> >I am running a Query that pulls from a FIELD called BANK in a TABLE called
> > ACCOUNT INFORMATION.
> >
> > The field BANK shows the actual name of my selected bank when viewed in the
> > query.
> >
> > In the REPORT ... the BANK Field shows the BOUND VALUE.
> >
> > How do I get the REPORT to actually show the DISPLAYED rather than the BOUND
> > value?
>
> Get rid of the lookup field in your table. It will cause a bunch of headaches
> just like the one you have now. The table that contains the lookup display
> value needs to be included in the query for the report so you can pull in that
> field.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
|