Repeating Database fields

[grimpirate]

I was hoping maybe someone around here had dealt with this problem before. I'm trying to insert a database field twice into a text document. So for instance something like,

<First Name><First Name>

And my database only has two records with First Name which are 'grim' and then 'pirate'. Basically, when I print this form letter I would like the results to be:

grimpirate

But instead I get

grimgrim

What am I doing wrong?

[foxcole]

I was hoping maybe someone around here had dealt with this problem before. I'm trying to insert a database field twice into a text document. So for instance something like,

<First Name><First Name>

And my database only has two records with First Name which are 'grim' and then 'pirate'. Basically, when I print this form letter I would like the results to be:

grimpirate

But instead I get

grimgrim

What am I doing wrong?

Your database has two separate records, but for your document, only the first record has been read in, so the only First Name available is 'grim'. Could I ask what you're trying to accomplish? Could you put the 'pirate' name in the first record, under a different label such as <Next Name. so instead of <First Name><First Name> you'd have <First Name><Next Name>? If that doesn't work, there may be a way to read the next record and use it (the first record becomes no longer available) but I've never tried it. Anyway, perhaps a more specific description of what you're trying to design will help.

Also, have you had a look at the Survival Guide? That lists some things you should include in every new post, and gives some tips and suggestions.

[grimpirate]

I purposely oversimplified the problem in order to make it easier on the people who read this foxcole. What I was trying to do was figure out how to make labels without using the label wizard. I already figured it out in any case. The idea is to have two or more of the same field on the same page but with different values and you do that by inserting between them a Next Record field. It can be found under Insert >> Fields >> Other

[foxcole]

I purposely oversimplified the problem in order to make it easier on the people who read this foxcole. What I was trying to do was figure out how to make labels without using the label wizard. I already figured it out in any case. The idea is to have two or more of the same field on the same page but with different values and you do that by inserting between them a Next Record field. It can be found under Insert >> Fields >> Other

Ah! I see now. Thanks for posting the solution.

Please edit your first post and add [solved] to the subject line, so others know they can find an answer here.