How do I limit the number of records?

[HLMack]

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.

 

[Jeff Boyce]

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]

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]

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