Jump to content
Andrew6000

If yes selected show a field, if no selected do not...

Recommended Posts

Andrew6000

Hello all.

I have a series of fields. Each has a 'yes' or 'no' based on a simple value list.

If the user chooses yes, i want another field to show up right next to it. If no, then nothing should show up.

 

At the very least i would like it to skip the next field if the user selects no.

 

Finally, this has to work automatically (from a calculation of somesort).

 

Does this make sense?

Thank you all so much!

Share this post


Link to post
Share on other sites
Johnny Boy

Off the top I'm thinking different layouts. May be Text same color as background. Just a couple of suggestions.

John

Share this post


Link to post
Share on other sites
Maarten Witberg

you can do this with portals.

 

based on the record ID and the value list, make a calc

 

match1=ID&your_field

and a match field:

match2=calc=ID&"yes"

 

make a self join relationship between the two fields.

 

draw a one-row portal in the layout based on that relationship. set the portal to the background color. Put the desired ::field in it. If "yes" then it'll show.

 

kjoe

smile.gif

Share this post


Link to post
Share on other sites
Andrew6000

I am not folowing, Could you explain in a bit more detail please?

 

thank you so much!

Share this post


Link to post
Share on other sites
Maarten Witberg

go to www.databasepros.com and locate the sample called visible.fp5.

 

gives a neat example (and more!) of the above principle of showing a field in a portal based on a self join relationship.

 

you can pry it open and see how it works.

 

if you wish, i can send you a sample of what I described in my first post. send me a pm with your email addres then.

 

kjoe

smile.gif

Share this post


Link to post
Share on other sites
Andrew6000

Thank you SO SO SO much!!!

Share this post


Link to post
Share on other sites
Punith baskar

when i click new record in the portal it deletes only one record instead of all records...that means the portal does not clear the old record values when i click the new record button...the portal records are displayed from the master table..

Share this post


Link to post
Share on other sites
doughemi

Please explain your problem more fully.

 

I think what you are saying that when you add a new record, the portal still shows the previous related records. This usually means that the relationship is incorrectly defined.

 

Please describe the two tables more completely, and be very specific about the relationship between them.

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use