infor.com
concierge
infor u
developer portal
Posts
Categories
Groups
Hubs
Developer
Healthcare
Hospitality
Public Sector
CloudSuites
Aerospace & Defense (LN)
Automotive (LN)
Chemicals (M3)
Corporate (FSM/HRT)
Distribution (Sx.e/CSD)
Distribution Enterprise (M3)
Engineering & Construction (LN)
Fashion (M3)
Food & Beverage (M3)
Healthcare (FSM/HRT)
Industrial (Syteline/CSI)
Industrial Enterprise (LN)
Manufacturing (M3)
Public Sector (FSM/HRT)
Solutions
Supply Chain Management (SCM)
Human Capital Management (HCM)
Events
Groups
Your Groups
User Groups
Migrated Forums
FSM/HCM/S3 - Infor Lawson 10.x
HCM/S3 - Learning and Development
HCM/S3 - Global HR
HCM/S3 - Talent Acquisition
HR Service Delivery
Human Capital Management (HCM) - EMEA
Infor Configuration Management for Service Industries
Lawson - Business Intelligence
Lawson - Financials
Lawson - Human Resources
Lawson - Supply Chain
Lawson - Supply Chain Management
Lawson - Technology
MSCM on Landmark
About
Community News
Email Community Support
Home
Groups
VISUAL - Enterprise Customer Community
Relational maps and field identification
pluna
Hello, I was wondering if there is a guide on the relationships between each table in Visual database? And also what about where each field in Visual interface window is located in the database?
Find more posts tagged with
Comments
Legacy Contributor
Me too. Considering that this is the INFOR community, I'd like to see someone chime in - why isn't the schema available to the level 5 users?
systemsadmin
if you have SQL server for a backend for your implementation of Visual, I recommend becoming familiar with Sql Server 2005 Management Studio:
www.microsoft.com/.../details.aspx
You can install this on a client machine so you don't have to remote into the server you want to administer. Also, it says 'express edition', but you can manage other versions of SQL server 2005 with it. Just grab the x86 or x64 version matching the OS of the machine you want to run it on.
Running this, you can drill down to the table level, right click, and choose 'View dependancies" on a table to at least show that much - you can only see relationship diagrams you manually create (Infor does not seem to do this). Check out this guide if you're interested:
www.devx.com/.../1954
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
CPQ: Ask a Colleague
FAQs, How-To, and Best Practices
Idea
Infor OS Portal
UI Design
CPQ: Tips and Tricks
Infor Homepages
Widget Development
Infor EPM Migration
Infor Ming.le