Bil Simser
|
| Posted: 04/15/2002, 12:19 PM |
|
Hi guys,
I'm just evaluating CodeCharge and find it great. I'm trying to build a fairly simple app to test it's flexibilty and decide if we want to get it for future projects. The one form I'm building is basically a regular Record type form with two exceptions.
First, I want to put the fields into groups. For example, the first 2 fields I want to group as "Project Characteristics". For grouping I just want the "td" tag to extend across both columns. Seems simple enough but I can't figure out how to do it. I've created a field of Label type with a caption call "Project Characteristics" and set it to be HTML but can't seem to modify the "td" tag.
The second problem seems simple as well (at least I think so) but can't figure out how to do it. In the form (a Use Case) there's a listbox for the project the Use Case belongs to. This is no problem as I've hooked it up to the projects table and all is well. The problem arises that I want to display a different field from the project database on the form. The ID for the Use Case is built from a 3 character code from the project record and the autoincrement field (key field) from the current record. I want to assemble this (project.project_code+usecase.reference_number) into something that will be automatically displayed in the form header. Any ideas on how to get this? I know I have to create a variable but I"m not sure how to do the lookup.
Thanks in advance if anyone can help. The product looks good and I'm hoping it will be flexible enough for future projects.
liB
|
|
|
 |
Nicole
|
| Posted: 04/16/2002, 2:32 AM |
|
Bill,
1. add empty Label field to create separator. In case you use templateless version create Custom Show form event to be able to edit html the way you like.
2. Use custom sql to display several fields as one. The common approach for custom sql that is used for ListBox field is:
select id_field, showing_field frm table1, table 2 Where <custom_where_clause_if_need>
So, build custom sql using db concatenation functions, test it against db and while it works correct and two fields are selected just copy it to CC project.
|
|
|
|
|
