Portal Engine
Version 2.x > Portal Engine > Document Types & Foreign Keys View modes: 
User avatar
Member
Member
matt - 1/11/2007 5:14:40 PM
   
Document Types & Foreign Keys
Is there any way to use cross lookup tables in document types?

For example...

There is a job opening document type. Say each job opening needs to be categorized by departments. It would be easiest to have a Departments table that I could draw the ID from to populate a new job opening.

Is there a way to accomplish this without having to write a custom web part? Can I point a field in the job opening table to an ID in another table from within the Kentico Site Manager?

I can do it as a custom web part, that's easy. But it would be amazingly useful if document types already handled this somehow.

-Matt

User avatar
Guest
admin - 1/20/2007 6:09:02 PM
   
Re: Document Types & Foreign Keys
Hi Matt,

I'm sorry for the delay in answering your message. If you need to create a lookup table, you can use the BizForms module to define the lookup table and define the field type in the job opening document type as a drop-down list that uses your SQL query to select the items from the BizForms-based lookup table.

Please let me know if this works for you.

Best Regards,