Rich Text

[James Peterson]

In our application we have a table named "setup" that contains the users name, address, etc. This setup information is to transfer to the heading of an Invoice Form by using Rich Text.

We have tried, with no success, to add the setup table to the invoice.set, on a one to one basis, so these fields could be added to the heading of the Invoice Form.

The manual has been read and provided no help in this instance.

[Tom Cone Jr]

RE: Rich Text

James,

I do something like you describe in my apps, too.

There are probably several different ways to get the user's info on the top of the invoice report layout. Here's how I do it.

1) When the app opens my autoexec script opens the 'setup' table, retrieve's the user's info, field by field, and stores each in a global variable.

2) if the user edits the table, my data entry form for that table has been modified to update the related global variables when they make changes.

3) In my report layout I declare global variables with the same names as used in my autoexec script and then drop them into the layout. This permits the user to update the invoice report if their area code or zip code changes, or even if they move to a new location.

Works like a charm.

-- tom

[James Peterson]

RE: Rich Text

Tom,

Is there a way to accomplish this using Rich Text tool and somehow picking up the fields from the setup table and placing them on the invoice form?

I can make a report using just the setup table and place the fields using the Rich Text Tool. However, after adding the setup table to the invoice table, I can place the necessary fields from the setup table onto the invoice form, but when printing the fields do not show. Any text such as the period after the city field does show.

Jim

[Tom Cone Jr]

RE: Rich Text

Jim, if the setup table were linked one to one with the parent table in your set it should work just like any other field in the parent table. Just drop the rich text object on the report layout (page header section?) and then drag / drop the fields on to the rich text object. -- tom

[James Peterson]

RE: Rich Text

Tom,

I made the set again, but instead of One to One I chose One to One(closest match). It worked. Have no idea why this would make a difference.

Jim

[Tom Cone Jr]

RE: Rich Text

James,

It's hard to tell from here, since we can't see your tables, or your set design. My guess is that the way you were defining the link, and the key field values in each table, explain what you experienced.

-- tom