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
How do I create a query that returns a BO + references?
-
- Posts: 58
- Joined: Wed Feb 22, 2012 9:44 am
- Location: New Zealand
- Contact:
How do I create a query that returns a BO + references?
Gary Bartlett
gary.bartlett at prodsol.com
[Aware IM 5.8]
gary.bartlett at prodsol.com
[Aware IM 5.8]
-
- Posts: 58
- Joined: Wed Feb 22, 2012 9:44 am
- Location: New Zealand
- Contact:
-
- Posts: 58
- Joined: Wed Feb 22, 2012 9:44 am
- Location: New Zealand
- Contact:
Got an answer from Rocketman, offline (I sent him a private email asking for help):
Worked perfectly!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
Gary Bartlett
gary.bartlett at prodsol.com
[Aware IM 5.8]
gary.bartlett at prodsol.com
[Aware IM 5.8]