Defining keys for object with complex key

[AndrewBaines]

In my DB, I have SiteName, with PK consisting of both SiteID & RegionID, both numeric.
How do I define this as the Primary Key in Universe Designer? If I click Detect, it only finds RegionID (wrong), but I'm not sure how to add both.
Thanks
Andrew

 

[blom0344]

Well, as long as you have properly defined joins between your table, then the key-detection has academic value. The detection itself is an aid for proper join creation in the first place..

Ties Blom

 

[skrandel]

From the sounds of it, you're trying to use the Index Aware capability. Then this matters ALOT. I don't know for sure, but I don't think there is anything in there that will do a multi-column primary key.

Steve Krandel
Intuit

 

[AndrewBaines]

Steve - thanks for your help. I'm trying to get the lookups to work without querying a whole stack of excess data. Looks like I'm trying to do the right thing, just the Universe designer doesn't support what I'm doing - it badly needs an update, feels very 1990s now!
Thanks
Andrew

Andrew Baines

http://www.pursuittechnology.co.uk