Method Community

Given: a dropdown used to create a relationship must be based off a unique field in the corresponding table. Situation: Values are not unique within a single field, but rather a combination of fields. Goal: Create uniqueness to these fields as a group, and relate the corresponding table to another table. Question: Is method capable of creating ...

Hi, just bringing some closure to this thread since u have now addressed  this issue w/ me in another post. Thanks for looking into the possibility of displaying field names in the edit wizard to make differentiating between them during customization alot smoother. ~Joe

Hi. Ahhh that's where they hid it. eheh. Didnt realize the default method screens would have fields with altered captions. Adding a section to the edit wizard, there's the words i was looking for =) ! I've been asked to change the occasional field caption to something very different from its original field name. Being able to see ...

Hey Joe, Take a look at those fields again, they are listed under the ShipTo/BillTo Address. If you look in the field list you will find; Shipaddresscity, Shipaddresscountry, Shipaddresszip, Shipaddressstate As well as Billaddresscity, Billaddresscountry,billaddressstate, billaddresszip What you are reading on the screen is the caption set ...

Ryan, Sorry to have taken up your time on this. Thanks for your response! I found the same thing that you did. I haven't found any settings in which to change this item either. The preferences do not affect that particular data field. Will do more research on that later though. Again, sorry to have taken your time up on this ...

Hello, If you open up the screen "Customer List", you will find that there are 2 places on screen with fields: city / state / zip / country. If you then direct yourself to the tables/fields you will find that these fields do not exist (at least by this name) in the table. At one point i totally lost these 2 fields from my screen ...

Thanks much for the guidance! I understand the development process so I really appreciate the heads up on your possible time frame.  I'm planning on working on this next week.  

I understand that. My situation was that at one point i was moving cells around >alot< and found that i had fumbled around 2 fields with the same caption and had no way to tell which was which. Which "City" was the ship to ? ... Which "City" was the bill to? ... from the tables/fields section yes they are seperated and ...

Nothing in there right now that could limit the response by an exact number of records..... You could try "RecordID < 101" to grab the first 100 (assuming no deletions).  Not really what you are looking for, but might solve the problem for now. Paul

Hello, I'm experimenting with the API and wanted to just browse some of the data in some of tables. To put it more simply, I'd like to run the equivalent of this SQL query over the API. Select Name from Customers limit 5; It looks like I should be using the MethodAPISelect_XML to accomplish this. In the documentation I see some ...