visuallogic

Hello, I'm trying without success to do the following... I have a portal with a Artist table as context. I have related another ArtLabourItems table in another file to the Artist table. Then I have a ArtLabourType dropdown field in the portal that defines an automatic value list from the ArtLabourType field in the ArtLabourItems table. This works fine. There is also a Price field in the portal that is defined as a calulation. When a ArtLabourType is selected from the dropdown I want the Price field to lookup its value via a calulation from the ArtLabourItems table. Basically I just want to select a value in the dropdown and then have other portal fields automatically filled in. Right now when I select the "One Hour" option from the dropdown I get a "?" in the portal Price field when using the following calculation for the Price field... Case( ArtworkLabourType = "One Hour"; Lookup (ArtworkLabourItems::ArtworkLabourBasePrice); ArtworkLabourType = "Elaborate";"1000"; "0") How do I get this to work? Thom

I've just completed a database but have a few outstanding issues... 1) If I leave a layout with a tab control and then come back to it from another layout why does the first layout not remember what tab it was on? It ends up on a different tab, how can this be fixed? 2) With a portal in a tab and each time I create a record in that portal the tab control will jump to another one of its tabs, why is this behavior? How do I stop this from happening? Best Regards, Visual Logic