Method Community

 This seems to be working now.

Is there a way to rename a table without losing the relationship with the data stored in it?

I added a drop down field named "Warranty" to the "InvoiceLine" table. The dropdown pulls from another table with warranty periods. I then added this field to the InvoiceLineItems grid in the Invoice screen and publish. The screen shows the new drop down witht the list contents correctly. I select a value and then click update ...

Is there a more accurate eta for this functionality. I can't wait to see what you guys come up with.

When adding an object such as a text box to a screen. What is the data relationship between that object and the screen or underlying table? I want to add a notes field to the invoice screen. I understand I can add the field to the Invoice table and then add the field. Just wondering what the purpose of the other objects are and is there a ...

While customizing tables I ran across a scenario where I tried to delete a custom table but received the message below. "Table 'Warranty' is used in a relationship with another table currently. It cannot be deleted at this time. Delete the relationship field in the other table and you may delete this table." I looked through ...

 How do i filter records in the report desinger. Example - using the already built SimpleInvoice. It will display all invoices for all customers.

 Worked! Thanks.

Good deal. Thanks for looking into this.

When I preview my report everything looks great. When I do print preview method where it rips it to pdf. All my fonts go to MS San sarif and my logo gets distorted. How do I preserve the original look?