Method Community

Hi NeilRick, Just to ensure I'm clearly understanding what you're looking for, you want to have a Dropdown field called "Email Type" and this field will be available on both the Shipment and Email Sent screens? Currently you send out the shipment notification and that email is then stored on the Emails Sent screen, ...

[quote user="jpfiester"]Is there a way to accomplish this without creating lots of custom fields?[/quote] Just a table design tip on this one, create a separate table called Address with all the fields you want to store (address123, city, country, etc.) plus one extra field called AddressRecordID.  AddressRecordID will store the ...

@dottie, There's more than one way to do something like this. Here are my thoughts on a simple approach. First off, you would need to define which existing fields or add new custom fields for the data. I assume you will want to use the Customer table. Possible fields would include: JobPercent - a an integer or decimal ...

[quote user="John M"]How many grids can i have in screen?[/quote] You can definitely put 8 (or more) grids (of the same table) on a screen and use a custom filter for each one.  You can even mix in detached grids from other tables if you need.  There's a good set of actions available for working with Grids so you should be ...

Hi Stuart, I have been following this thread between you and Greg...... Forgive me if I am coming in the middle, but Report Designer does have its challenges and I have been working with it for a bit.  It sounds like your setup is where Parent or Family is Customer and then ...

How do you create a drop down in one table that references another table?

Great! Glad to hear. If you experience unexpected errors like these in the future, the first thing you should try is regenerating any related tables. Also, remember to always click Finished Editing Fields after you are finished working in a table.  Jason

Heh...yeah I actually thought about shoving data into some other table like as well. I think I'll probably just go ahead and create master/detail tables for this report. It's more straight forward/obvious that way and easier to maintain. Thanks

Hi handcrafted, In your string array of insert columns or your string array of insert values....are any of the values null? Dave

Aloha Fran, Thanks for jumping in.  All the better.  I am relatively new to Method and fyi my background was 30 plus years designing and coding business applications for Digital Equipment's OpenVMS systems.  If I had known more about Method and the integration with Quickbooks I might have approached this slightly differently, ...