tcoston
Posts: 2
|
| Posted: 01/12/2007, 7:58 PM |
|
CCS 3.1, Access DB
When I create a record, if I don't force all the fields that display in the associated grid with a value, the grid will not display the result. For example, New Record with values "firstname", "lastname" and "age" but only fill in "firstname" field and "lastname" field and leave "age" field empty. The record will go into the database. The grid shows firstname, lastname and age but because I did not put an age in the record, the record does not display in the grid. I can force a default value on the record or use validation to make sure all values are inputed in the Record form but is this by design or am I missing something when I set this up? I seems to me even if a record field is empty is should still display the result in the grid. I'm not a programmer but have been using CCS for about 4 years to do small projects here and there.
Any help would be great! Thanks!
--Todd
|
 |
 |
peterr
Posts: 5971
|
| Posted: 01/12/2007, 11:49 PM |
|
This looks like a problem with your datasource/database joins (SQL). You may need to join tables via left join, for example by double-clicking on the line that links 2 tables in Visual Query Builder. You can also see how correct joins look like at http://docs.codecharge.com/studio31/html/QuickStart/Cre...citRelship.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
