hunter Posted February 12, 2007 Share Posted February 12, 2007 I am trying to figure out a way to force users to enter data into a field that's in a portal. Setting the field to Validation - Not Empty won't work since the field is in a different table than the data-entry layout. I've tried setting up a calc field (in the data-entry layout's table) to populate when data is entered in the portal's field, but there isn't a way to set the Not-Empty validation on the calc field. I tried Auto-Enter, Calculation and Lookup in yet another field, based both on the first calc field, and also the field in the portal. This isn't working for me at all. The Auto-enry field remains empty. Am I missing something that's really obvious here? Thanks for any help! Lesley Link to comment Share on other sites More sharing options...
mr_vodka Posted February 12, 2007 Share Posted February 12, 2007 Are you talking about forcing the user to enter data into the empty portal row to create a new record? If not, then I am a little confused on what you need this for. The field validation on the child table's field will prompt the user if the field is empty in the child record whether its in a portal or not. Link to comment Share on other sites More sharing options...
hunter Posted February 15, 2007 Author Share Posted February 15, 2007 Yes, to force the user to enter in the portal, creating a new record in the child table. Setting up a field in the child table as Validate - Not-Empty doesn't work when entering data via the parent table. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 15, 2007 Share Posted February 15, 2007 Hi it works to me, but you have to find a way to commit the record in the portal Link to comment Share on other sites More sharing options...
hunter Posted February 16, 2007 Author Share Posted February 16, 2007 Thanks for your replies. It's just one field in the portal, so there isn't a record to commit, unless they enter in the field. We have power users who do not want a scripted entry, so we're living with the portal entry. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 16, 2007 Share Posted February 16, 2007 I'm not understanding... You said that you are creating new record by entering values in the portal...and that the field in the portal is only one...and that the field can't be empty. If that field is empty, you never create a new record and no other row may appear in the portal ! Link to comment Share on other sites More sharing options...
hunter Posted February 16, 2007 Author Share Posted February 16, 2007 Yes Danielle, that's correct. It's just a simple portal to pull in one piece of data into records. If they don't enter in that portal field, there will be no related record created to trigger the Not-Empty feature. I didn't build this database (I'm a developer on staff at a University where many departments also develop their own databases). I am not sure why they need to create related records for this data instead of using a value list... I thought I'd throw it out to the community to see if anyone had any suggestions. Link to comment Share on other sites More sharing options...
comment Posted February 16, 2007 Share Posted February 16, 2007 It is indeed a rather peculiar request. In most cases, requiring a child record to be created along the parent would indicate a problem in the data model. Nevertheless, I think it's not too difficult to accomodate. RequireChildRecord.fp7.zip Link to comment Share on other sites More sharing options...
Raybaudi Posted February 17, 2007 Share Posted February 17, 2007 Hi comment may be I'm sleeping, but I still can't understand ! If you delete the value, no error message comes out; but, if you set Child::value to be Not Empty, an error message always comes ( at commit time ) Link to comment Share on other sites More sharing options...
comment Posted February 17, 2007 Share Posted February 17, 2007 I'm afraid I am not following you. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 17, 2007 Share Posted February 17, 2007 What is hunter's wish ? 1) Always create a new record in the child table or 2) Always verify that that field isn't empty ?? Link to comment Share on other sites More sharing options...
comment Posted February 17, 2007 Share Posted February 17, 2007 Yes, my file only requires a child record to EXIST - not to have any actual value. But if you change the validation to: not IsEmpty ( Child::Value ) I believe it will do both. but, if you set Child::value to be Not Empty, an error message always comes ( at commit time ) This is the part I don't follow. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 17, 2007 Share Posted February 17, 2007 I was thinking that he needs a way to validate NOT empty a field placed into a mono-row portal. If that is correct, the simplest way is to set the "not empty" validation option of that field...and we don't care that that field is into another table or in the same table, the error message comes out in the same way. Link to comment Share on other sites More sharing options...
comment Posted February 17, 2007 Share Posted February 17, 2007 I am still not following you. Are you describing a solution or a problem? I don't see how you can validate a field as not empty (self) - if the record does not exist. Link to comment Share on other sites More sharing options...
Raybaudi Posted February 17, 2007 Share Posted February 17, 2007 Yes, to force the user to enter in the portal, creating a new record in the child table. ok, finally I understand ! He wished a way to: 1) Always create a new record in the child table AND 2) Always verify that that field isn't empty Link to comment Share on other sites More sharing options...
comment Posted February 17, 2007 Share Posted February 17, 2007 LOL, I thought it was me that did not understand... :party: Link to comment Share on other sites More sharing options...
Raybaudi Posted February 17, 2007 Share Posted February 17, 2007 Lol Now here in Italy is 02:43... sure I need to sleep more ! Link to comment Share on other sites More sharing options...
hunter Posted February 26, 2007 Author Share Posted February 26, 2007 Thank you for sending your solution! It works regardless of whether they need only a specific field to contain data or require that a child record is created. It forces data-entry before moving forward. Sorry this was so hard to understand! I failed to articulate well. Hunter Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6267 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now