| 
                                                                            
                                                                                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,
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |