>Hi,
>
>I'm beginning to work with views and don't know how to handle 0-1,1 relationships. I have a "Clients" table and for each client from Brasil I need extra data. So I create another table, that I'll call "Other". When I insert a record in the view, I can fill all data, but only want to add a record to the "Other" table if any field of this table (in the view) is filled. Any ideas ?
>
>TIA,
IMO, the better grid will contain all common fields only, i.e. view/cursor will be still based on one table. Additional grid.column will contain command button 'Other Info' which will appear (Column.DynamicCurrentControl) for country="Brazil" only. Clicking on the button a user will bring up a dialog dealing directly with Other table.
Edward Pikman
Independent Consultant