How do I create a query that returns a BO + references?

GaryBartlett

Hi,

I'm sure this is obvious, but I just can't work out how to create a Query that returns a table containing the BO attributes and its reference attributes.

E.g. I have a BO called Request, with attributes Number and Name and a reference attribute Requester. Requester is drawn from a BO called Contacts.

I want to create a Request query that shows

Number|Name|Requester

Thanks very much!

Gary

GaryBartlett

Oh dear - wrong forum - sorry Support!

GaryBartlett

Got an answer from Rocketman, offline (I sent him a private email asking for help):

In Request, create a attribute (type Shortcut) which points to contacts.name(or something - you can have more than one shortcut eg Firstname Surname)

Then put the Shortcuts into the query so Request.number, Request.Name, Request.shortcut1, etc etc

Worked perfectly!