bcooney

Turn on debugger and then open file. Step through the open script and see what’s causing error. That message occurs after your login has been accepted. This is a different issue.

That UI will not work out well when the Venue list becomes long. You can use the global field directly in a Find, no need to set a var. Also, OnObjectSave would be a better choice for this trigger than OnObjectModify, since it is a post-event trigger that will allow you to Exit False and keep the user in the field.

I’d store EquipmentId in the exam record, and relate them. No need to bring in all equipment field data to exam. Is it only one piece of equipment per exam? If not, you need a table ExamEquipment or a multikey, EquipmentIdList in Exam. I don’t understand this part. “I linked them using a single field "Used" in the Equipment table and "Is Avail" in the Exam table.“

Let’s take a product table as an example. One attribute is size. You could use a custom value list of hard coded choices: small, medium, large. However, if you decide that you’d rather have the choices : S, M, L, then you’d need to change existing data. Really, not a big deal. You can avoid this situation by using a value list based on a table. The user selects the Id from the size table. Now if you change the size choices, there’s no data conversion since the relationship is based on Id. Do you need to have a relationship from the parts table to the size table? No. As you see

Why not create a form view based on venue and show a portal to related events that venue?

What tables do you have? What table is record A? What is the table that the portal is based on? What is their relationship? You say the video is in record A? Is it or is it in the portal table? Perhaps what you need is a join table. This is the typical structure used to resolve a many-to-many relationship. For example, Actor->Roles<-Movies. Roles is the join table.

I would suggest setting the field in a nightly server script so it is stored.

If your customer list has an OnLayoutEnter sort, that should not affect the found set. When you say “sort,“ do you instead mean find active? also, gtrr from quote to customer would typically end on a customer form view. The trigger for active wouldn’t make sense on a form layout.

Do a find in the name field? You might want to only use the first three letters of the first name and last name to get a broader result.

3. Script any edit or creation or deletion of a child and set the total value in the parent. 4. use a on record commit trigger to set the total in the parent. both are methods to avoid the unstored value in the parent.

Why do you have duplicate data? The goal of a database is to limit such a state.

This is a misleading statement. Custom functions do not perform calculations faster than script calculations. The custom functions shown for packaging and parsing multiple values in a script parameter were developed by Six Fried Rice’s Jesse Antunes and described in their blog in 2007. http://sixfriedrice.com/wp/passing-multiple-parameters-to-scripts-advanced/ It is a matter of opinion whether it is better to have visibility into the parsing of parameters vs this method of having the receiving script use a custom function to declare parameters. I would recommend using JSON to pass p

No, you cannot nest popovers. Perhaps have the continue button create a new card window?

I posted this demo, maybe it’ll help. What you’re describing is usually called a picker. Often now accomplished using a card window.

https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/how-do-i-enter-credit-card-fees-when-receiving-a-payment-from-a/00/206708