How to make a dblookup like?

emontes

I??m very new with fast Reports, and I have a table with reservations, in this table I have a field named userID , and have another users table with the fields userID and UserFullName, then what I need is that the report show the UserFullName field.
How can I do that?

gordk

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

emontes

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

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

Just displaying the content of the second table

gordk

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.