Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004

    Smile Unanswered: How to replace field Ids with user friendly name!

    Hi there

    I have a form that has amongst fields Ids that are foreign keys in the underlying table, however on the form I want to be able to display the name instead of the field ids whilst the ids would still remain the same in the underlying table.

    E.g. I have bank id I what to be able to see bank name instead of the id.

    Pls. can anyone help me out pls?

    Many Thanks in advance.

  2. #2
    Join Date
    Sep 2003
    Waht do you mean? What kind of form is it? Ordinarily I'd say use an alias for your column name...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Apr 2004

    how to replace fields id with user friendly name.

    Hi Owen

    Thanks for ur reply?

    The form is form based on query made up of several tables and the cutomerID, bankId, that acts as foreign keys in the table when placed on the form show with the ids, I would like to replace this with eg customer name instaed of customer Id from the customer table.

    What do u mean by alias ?

    Many Thanks for ur help in advance.

    Much appreciated

  4. #4
    Join Date
    Apr 2004
    outside the rim
    In the query, type the name you want, followed by a colon right before the field name.

    For example: CuustomerID
    becomes: Customer Name Key: CustomerID

    This changes the name of the field to Customer Name Key.

    This is called aliasing.

    However, it sounds like you have the related keys and want another field from the record to show up - CustomerID being the foreign key and CustomerName being the foreign data you want. In the query, link the two tables together and then either double-click or drag the fields you want down to the grid.

    Hope this helps.
    have fun!

    Todd S.
    click to email

    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET

    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  5. #5
    Join Date
    Apr 2004
    Hi tcace

    Many many thanks for ur reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts