I have a database "Bricks" with 4 fields; Line1, Line2, Line3, Line4. The
user opens a form to input data (limited to 15 characters per line) and
clicks a "Preview" button that displays these 4 lines superimposed over a
brick image. The purpose is for the individual to see how the brick will look
before ordering. I don't want the database to grow but would like to pass
this data to another database for orders when the customer is satisfied. Am I
going about this right or is there an easier way to accomplish this. Thanks
in advance.

I don't know about "easier", but if you have four fields in a table with
names of "Line1", "Line2", "Line3", and "Line4", you don't have a database,
you have a spreadsheet. Is there a reason you aren't using something like
Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"HLMack" <(E-Mail Removed)> wrote in message
news:FA42FF37-B02A-4A89-865F-(E-Mail Removed)...
>I have a database "Bricks" with 4 fields; Line1, Line2, Line3, Line4. The
> user opens a form to input data (limited to 15 characters per line) and
> clicks a "Preview" button that displays these 4 lines superimposed over a
> brick image. The purpose is for the individual to see how the brick will
> look
> before ordering. I don't want the database to grow but would like to pass
> this data to another database for orders when the customer is satisfied.
> Am I
> going about this right or is there an easier way to accomplish this.
> Thanks
> in advance.

Thanks Jeff. Bad choice of words on my part. I am putting together a database
for a non-profit organization and part of that is individuals buying
"memorial bricks." I should have said a "table bricks" which is part of the
contributors table. What I want to do is have forms where an individual can
enter 4 lines of data that he or she can then view superimposed over a brick
image. I don't want to keep this data until they decide on their final choice
for the memorial brick. I would then like to pass this data to a brick orders
table which would contain the fields Line1 thru Line4, individuals name, date
of purchase, amount, date brick received, and location of brick. Again,
thanks.

"Jeff Boyce" wrote:

> I don't know about "easier", but if you have four fields in a table with
> names of "Line1", "Line2", "Line3", and "Line4", you don't have a database,
> you have a spreadsheet. Is there a reason you aren't using something like
> Excel?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "HLMack" <(E-Mail Removed)> wrote in message
> news:FA42FF37-B02A-4A89-865F-(E-Mail Removed)...
> >I have a database "Bricks" with 4 fields; Line1, Line2, Line3, Line4. The
> > user opens a form to input data (limited to 15 characters per line) and
> > clicks a "Preview" button that displays these 4 lines superimposed over a
> > brick image. The purpose is for the individual to see how the brick will
> > look
> > before ordering. I don't want the database to grow but would like to pass
> > this data to another database for orders when the customer is satisfied.
> > Am I
> > going about this right or is there an easier way to accomplish this.
> > Thanks
> > in advance.
>
>
>

Think "art", not "science"...<g>

One way to approach this would be, as it sounds like you have now, a record
that uses 4 fields to store the proposed text of the four lines
(separately). If you also add a Yes/No field to indicate that the text
entered is "their final answer", you wouldn't have to move text from one
table to another.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"HLMack" <(E-Mail Removed)> wrote in message
news:13383901-7CFE-4D6B-BC69-(E-Mail Removed)...
> Thanks Jeff. Bad choice of words on my part. I am putting together a
> database
> for a non-profit organization and part of that is individuals buying
> "memorial bricks." I should have said a "table bricks" which is part of
> the
> contributors table. What I want to do is have forms where an individual
> can
> enter 4 lines of data that he or she can then view superimposed over a
> brick
> image. I don't want to keep this data until they decide on their final
> choice
> for the memorial brick. I would then like to pass this data to a brick
> orders
> table which would contain the fields Line1 thru Line4, individuals name,
> date
> of purchase, amount, date brick received, and location of brick. Again,
> thanks.
>
> "Jeff Boyce" wrote:
>
>> I don't know about "easier", but if you have four fields in a table with
>> names of "Line1", "Line2", "Line3", and "Line4", you don't have a
>> database,
>> you have a spreadsheet. Is there a reason you aren't using something
>> like
>> Excel?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "HLMack" <(E-Mail Removed)> wrote in message
>> news:FA42FF37-B02A-4A89-865F-(E-Mail Removed)...
>> >I have a database "Bricks" with 4 fields; Line1, Line2, Line3, Line4.
>> >The
>> > user opens a form to input data (limited to 15 characters per line) and
>> > clicks a "Preview" button that displays these 4 lines superimposed over
>> > a
>> > brick image. The purpose is for the individual to see how the brick
>> > will
>> > look
>> > before ordering. I don't want the database to grow but would like to
>> > pass
>> > this data to another database for orders when the customer is
>> > satisfied.
>> > Am I
>> > going about this right or is there an easier way to accomplish this.
>> > Thanks
>> > in advance.
>>
>>
>>