Jump to content

Recommended Posts

Hi all,

First, I'd like to thank you in advance for help.  I'm having some "newbie" troubles, please don't beat me up too bad.  

I'm writing a script that I would like to accomplish several things, however, I am having trouble with the easy part.  I'm trying to have a custom dialog box to popup and have the user to enter name of a facility, which then attached that name to a global field.  (ie g_CompanyName)  I also have a layout (receivables) with a field that is a dropdown box that is referring back to a list of facilities and their contact/address/numbers data.  (ie facilitiesIDfk)  

At this point, I can go to that layout (receivables), I can click the dropdown box, choose the name of the facility, it populates the facility data (address/phone#/etc), Then the receivable data can be entered.

I am trying to get the script to pop up a custom dialog box that takes me to the (receivables) layout, ask "what is the facility?", enter part or all of the name (companyABC), it enter that data into the (facilitiesIDfk)(which is the dropdown to choose from), it finds and chooses "companyABC", then allows me to finish the input.

Question: Should I make a separate layout with the fields "global", then enter those into the script or is a simple custom dialog box sufficient?  

Again, thanks so much any help.  

Have a great day!

Edited by Helias

Share this post

Link to post
Share on other sites

Yes you can use a dialog box.  You can use a global field in the custom dialog so that your users can enter the search criteria.  Then in your script, you would search "companyABC" in the related field.  You can't search for it directly in the facilitiesIDfk field as that seems to only store the key.  So if you haven't already create a relationship from facilitiesIDfk  to a table occurrence of your facility table.  Then have your script search the facility name in that related table.

Share this post

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    2 members have viewed this topic:
    reynir  DavidTO 

Important Information

By using this site, you agree to our Terms of Use.