How to make a dblookup like?

Comments

• gordk St.Catherines On. Canada.

  February 2006 edited 6:48AM

  not really sure of what you are asking or trying to acheive
  more info Please?
• emontes Cancun

  February 2006 edited 6:48AM

  In the table 1 I have a structure like this:
  orderID --> AutoNumeric
  orderDate -->Date
  userID --> Numeric (The user asigned to this order)
  ......
  
  In the table 2 I have a structure like this:
  userID --> Numeric
  userFullName -> String (The User Full Name)
  ........
  
  Well, that I need is that in the Orders Report (Table 1) appears the user Full Name as a String instead of its numeric value
  
  Thanks
• gordk St.Catherines On. Canada.

  February 2006 edited 6:48AM

  are you talking about using a lookup on the fr dialog form or just having the data from the 2 tables available in the report?
• emontes Cancun

  February 2006 edited 6:48AM

  Just displaying the content of the second table
• gordk St.Catherines On. Canada.

  February 2006 edited 6:48AM

  this will depend upon the external data linkage relationship of the tables that are connect to the frxdbdatasets, or if using internal frxdataengine controls, the linkage you set up between tables/queries. You can also use a joined query to retreive all data fields required. Suggest you read and study the examples in the user manual and in the demos\main\ demo.