Then the description will appear in the field (as a pulldown) and you don’t see the keyvalue. If you don’t have too much campus description and you don’t want to show the keyfield with description you can change the fieldtype to ‘select’ type and follow similar steps to add the appropiate sql. It will show the description of the field behind the keyfield. Select correct table name (campus-master). Go down to the grid lookup and check use lookup. Open fields in your left menu and select campus key. it shows up as description.Īfaik: Create a form using campus description. It did show up correct,but beside an empty box. I did try the grid lookup section by inserting this sql: select a.campus from campus_master a, user_profile_campus73 i was asking how to do that for a new field? So in theory, im gonna have to link by query using the campus_key between the tables to get the name. Now i’m going to need to show campus_name on the forms because showing campus_key would be pointless to user. there is another table which holds the campus names by their key at the campus_master table. but from what you can see, there is no name for campus in that table. Now,im creating a form using the campus description to show user which access flag they are allowed from each campus. I have two tables which is campus_master and campus_description…Ĭampus_description USER_KEY | USER | CAMPUS_KEY | ACCESS_FLAG | Let me give you a simple example of my situation.(im using oracle database): i did try the grid lookup section but it doesnt show as value but rather as description and an empty box beside it. Perhaps my situation isn’t clear yet or i’m still struggling with the tools. Click the checkbox ‘Use lookup to display the field description.’ and generate the lookup SQL Command. Is that what you mean? Don’t change the field type (text, number), but go down to grid lookupsection. So you don’t need a link here to replace the capus id by the campus description. You can have an autolookup on any field replacing the keyvalue by the description. I don’t quite understand what you want to achieve.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |