How to copy information to a new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a database about user request some server for some application
each user can request many many server,
so i would like to make a copy function in the form,
such that, after the user input all information,
then he can press the copy button,
then it will automatically open a new record and paste all previous input
information, then user only need to re-enter the requested server field,
such that they no need to enter other things so many times.

I know that there is a shortcut Ctrl' can copy record,
however the user do not satisfy with it,
they would like a real button for them to click,
is there any other solution?
 
is there any other solution?
Click to expand...

Yes. Redesign your tables so that they are properly normalized. You
should NEVER need to maintain multiple copies of redundant data! It
sounds like you have a many (application) to many (server)
relationship; the proper way to handle this is to have a table of
Applications, a table of Servers, and a junction table with just the
ApplicationID and the ServerID as links to these tables.

John W. Vinson[MVP]
 
i understand that,
however the user request me to put all thing in one table,
they say it is hard for them to maintance for so many tables.

is there any other solution besides redesign
 
i understand that,
however the user request me to put all thing in one table,
they say it is hard for them to maintance for so many tables.
Click to expand...

If they were to use Excel, would they insist that the spreadsheets
should not have any formulas because they're so confusing?

If they were to use Word, would they insist that no themes, templates,
or variable fonts be used because they're too distracting?

In a well designed database, it's EASIER to maintain multiple tables
than it is to maintain one. Your question is a perfect case in point:
you're having difficulty maintaining the database because you need to
copy data redundantly. The user should never even *see* a table, or a
table datasheet; all their interaction with the data should be through
Forms.
is there any other solution besides redesign
Click to expand...

Sure. Get some 8 1/2 x 14" yellow legal pads and a supply of pencils.
Or use a single Excel spreadsheet if you want to use the computer.

Sorry to be sarcastic, but no - there is no good solution besides a
*PROPER* redesign.


John W. Vinson[MVP]
 
Back
Top