sharabi Posted May 13, 2006 Share Posted May 13, 2006 lets say i have two tables, the first is [color:green]TEMPLATE and the second is [color:green][color:green]PATIENT, TEMPLATE has two filds where i store the templates for pathology reporting first field is [color:red]template name, the second field is [color:red]gross description. i would like to have a pull down menu on the [color:green]PATIENT lay out that will display the templates names and when i choose one i would like the gross description field from the [color:green]TEMPLATE table to be inserted in the gross description field in [color:green]PATIENT table(patient layout). is there any thread or referal to an article that can help me with this type of automating text entry. also i would like to save back or add more templates as i continue adding to my data so i would like to know what is the best script for the reverse process. i know am asking for much but this forum is the only place to turn to. thx. Link to comment Share on other sites More sharing options...
sharabi Posted May 16, 2006 Author Share Posted May 16, 2006 hello there ? Link to comment Share on other sites More sharing options...
sharabi Posted May 17, 2006 Author Share Posted May 17, 2006 am i missing something .i wonder if my post is visible? can someone tell me if i made a mistake or i did something wrong so no one is responding to my queston after 4 days? Link to comment Share on other sites More sharing options...
Genx Posted May 17, 2006 Share Posted May 17, 2006 No, your post is just a bit vague. I get the first bit (attached) but the second part is a bit confusing... test.zip Link to comment Share on other sites More sharing options...
Dr.Hamed Posted May 18, 2006 Share Posted May 18, 2006 Thanks GenX. This works beautifully. The other thing is: If I have a record in PATIENT table that i want to add to TEMPLATE table - to become a new record in the popup menu-. Link to comment Share on other sites More sharing options...
Genx Posted May 18, 2006 Share Posted May 18, 2006 You can do one of two things (one involves some dodgey work with relationships, so im not going to bother). So, straight on to two. Let the user enter whatever they want, i.e. use a drop-down vs. a pop-up. Next to the field add a button i.e. "add to template collection" The script attached to this button would be simple Allow User Abort [off] Set Error Capture[on] Freeze Window SetVariable[$template ; Patient::templatename] SetVariable[$description ; Patient::grossdescription] Go to Layout[The template one, i forget what i called it... probably template] New Record / Request Set Field[Template::template ; $template] Set Field[Template::grossdescription ; $description] Committ Record / Request Go to Layout[Patient Layout] Thats about it, that adds it for you to the rest of the lot. Any troubles with this yell, careful with my script, its a bit rough so in some of the script steps when working in script maker there might not be a space where i put a space etc. ~Genx Link to comment Share on other sites More sharing options...
Dr.Hamed Posted May 18, 2006 Share Posted May 18, 2006 Many thanks. It works great. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6553 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