Hi guys,

I have 4 basic tables which are related and I would like to show as much info as possible in a single form like this:

The tables are:

• Insured: Main parent table
• Policy: related to Insured
• Vehicle: related to Policy
• Driver: related to Vehicle

What I am trying to do with the above form layout is to have the Insured data upfront and then allow the user to enter any detail data via the ListView at the bottom.  I am not sure if the above relations can be handle by SF on the same form in order to show all related data to its parent as well as to update the FK fields in the child BOs?

I would appreciate any suggestion/indication for the above form layout.  At this point I am exploring all new things I can do in .NET.

Thanks!

Edhy Rijo

Hey, Edhy...maybe this will look a little better.  I attached a jpg of a screenshot.  The embedded image in the body of a thread does gets a bit distorted.

Talk to you later,
Bill

Hi Bill,

Thanks for the screenshot, it is much clear.  Now I see what you meant, believe or not I have done this kind of design in Visual FoxPro long, long time ago and I think I will follow the page tabs even though the relation of my child tables are not to the same parent table, but guess will look better than the plain ListView control and will give me a chance to incorporate any new data.

One question, how do you get the combobox to display the message [Select an Address] for NULL/empty values? 

Edhy Rijo

Edhy, check out the TopMostValue property of the combo. I think that is how Bill is doing it (that's how I'd do it). Set the text to whatever, the value to the value you return in your BO if the value is NULL (from BO mapper settings).

You can be rather creative in the tab pages...not limited to ListViews, of course.  So far, I have kept them to a toolbar and listview; however, the sky's the limit...charts, graphs, reports, etc..

Greg is right (hey, Greg!) about the combobox.  I use that to try to prompt the user into proper action.  For some reason, a blank combobox is usually left blank.

Bill