~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brian Leary" <brianleary@h...>
Subject: [asp_databases] Creating a template record


: I am creating an online database that collects information on job
: postings. I was wondering if there was an easy way to create a template
: record with pre-populated data so I don't have to type all the information
: in the form again. In some cases only a few fields in the form will be
: different so I don't want to have to type the same info over and over.
: My thought is that the users could flag a record as a "template" and then
: I could somehow use this template to create new records. Does anyone have
: any suggestions for me ?
: Thank you

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Why not have a table called "JobTemplates" and store the template positions
in there?

Then, when a user wants to create a new position then could select from a
drop down list of existing templates, or create a one from scratch.

Cheers
Ken

Somewhere hidden in this message I will find your response.
Thanks
Brian 




UHV0IGEgY2hlY2tib3ggb24gdGhlIGZvcm0uICBJZiB0aGUgdXNlciBjbGlja3MgaXQgcHV0IGE
g
amF2YXNjcmlwdCBpbiB0aGUgaHRtbC9hc3AgdG8gZmlsbCBpbiB0aGUgdGVtcGxhdGUgZm9yIHl
v
dS4NCmRvY3VtZW50LmZvcm1uYW1lLmZvcm1maWVsZC52YWx1ZSA9ICJibGFoYmxhaCI7DQoNCgk
t
LS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBCcmlhbiBMZWFyeSBbbWFpbHRvOmJ
y
aWFubGVhcnlAaG90bWFpbC5jb21dIA0KCVNlbnQ6IFR1ZSA0LzE2LzIwMDIgNjoxMCBQTSANCgl
U
bzogQVNQIERhdGFiYXNlcyANCglDYzogDQoJU3ViamVjdDogW2FzcF9kYXRhYmFzZXNdIENyZWF
0
aW5nIGEgdGVtcGxhdGUgcmVjb3JkDQoJDQoJDQoNCglIaSwNCglJIGFtIGNyZWF0aW5nIGFuIG9
u
bGluZSBkYXRhYmFzZSB0aGF0IGNvbGxlY3RzIGluZm9ybWF0aW9uIG9uIGpvYg0KCXBvc3Rpbmd
z
LiBJIHdhcyB3b25kZXJpbmcgaWYgdGhlcmUgd2FzIGFuIGVhc3kgd2F5IHRvIGNyZWF0ZSBhIHR
l
bXBsYXRlDQoJcmVjb3JkIHdpdGggcHJlLXBvcHVsYXRlZCBkYXRhIHNvIEkgZG9uJ3QgaGF2ZSB
0
byB0eXBlIGFsbCB0aGUgaW5mb3JtYXRpb24NCglpbiB0aGUgZm9ybSBhZ2Fpbi4gSW4gc29tZSB
j
YXNlcyBvbmx5IGEgZmV3IGZpZWxkcyBpbiB0aGUgZm9ybSB3aWxsIGJlDQoJZGlmZmVyZW50IHN
v
IEkgZG9uJ3Qgd2FudCB0byBoYXZlIHRvIHR5cGUgdGhlIHNhbWUgaW5mbyBvdmVyIGFuZCBvdmV
y
Lg0KCU15IHRob3VnaHQgaXMgdGhhdCB0aGUgdXNlcnMgY291bGQgZmxhZyBhIHJlY29yZCBhcyB
h
ICJ0ZW1wbGF0ZSIgYW5kIHRoZW4NCglJIGNvdWxkIHNvbWVob3cgdXNlIHRoaXMgdGVtcGxhdGU
g
dG8gY3JlYXRlIG5ldyByZWNvcmRzLiBEb2VzIGFueW9uZSBoYXZlDQoJYW55IHN1Z2dlc3Rpb25
z
IGZvciBtZSA/DQoJVGhhbmsgeW91DQoJQnJpYW4NCgktLS0NCglDaGFuZ2UgeW91ciBtYWlsIG9
w
dGlvbnMgYXQgaHR0cDovL3AycC53cm94LmNvbS9tYW5hZ2VyLmFzcCBvcg0KCXRvIHVuc3Vic2N
y
aWJlIHNlbmQgYSBibGFuayBlbWFpbCB0byBsZWF2ZS1hc3BfZGF0YWJhc2VzLTUzNzc1MFNAcDJ
w
Lndyb3guY29tLg0KCQ0KDQo

UHV0IGEgY2hlY2tib3ggb24gdGhlIGZvcm0uICBJZiB0aGUgdXNlciBjbGlja3MgaXQgcHV0IGEg
amF2YXNjcmlwdCBpbiB0aGUgaHRtbC9hc3AgdG8gZmlsbCBpbiB0aGUgdGVtcGxhdGUgZm9yIHlv
dS4NCmRvY3VtZW50LmZvcm1uYW1lLmZvcm1maWVsZC52YWx1ZSA9ICJibGFoYmxhaCI7DQoNCgkt
LS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBCcmlhbiBMZWFyeSBbbWFpbHRvOmJy
aWFubGVhcnlAaG90bWFpbC5jb21dIA0KCVNlbnQ6IFR1ZSA0LzE2LzIwMDIgNjoxMCBQTSANCglU
bzogQVNQIERhdGFiYXNlcyANCglDYzogDQoJU3ViamVjdDogW2FzcF9kYXRhYmFzZXNdIENyZWF0
aW5nIGEgdGVtcGxhdGUgcmVjb3JkDQoJDQoJDQoNCglIaSwNCglJIGFtIGNyZWF0aW5nIGFuIG9u
bGluZSBkYXRhYmFzZSB0aGF0IGNvbGxlY3RzIGluZm9ybWF0aW9uIG9uIGpvYg0KCXBvc3Rpbmdz
LiBJIHdhcyB3b25kZXJpbmcgaWYgdGhlcmUgd2FzIGFuIGVhc3kgd2F5IHRvIGNyZWF0ZSBhIHRl
bXBsYXRlDQoJcmVjb3JkIHdpdGggcHJlLXBvcHVsYXRlZCBkYXRhIHNvIEkgZG9uJ3QgaGF2ZSB0
byB0eXBlIGFsbCB0aGUgaW5mb3JtYXRpb24NCglpbiB0aGUgZm9ybSBhZ2Fpbi4gSW4gc29tZSBj
YXNlcyBvbmx5IGEgZmV3IGZpZWxkcyBpbiB0aGUgZm9ybSB3aWxsIGJlDQoJZGlmZmVyZW50IHNv
IEkgZG9uJ3Qgd2FudCB0byBoYXZlIHRvIHR5cGUgdGhlIHNhbWUgaW5mbyBvdmVyIGFuZCBvdmVy
Lg0KCU15IHRob3VnaHQgaXMgdGhhdCB0aGUgdXNlcnMgY291bGQgZmxhZyBhIHJlY29yZCBhcyBh
ICJ0ZW1wbGF0ZSIgYW5kIHRoZW4NCglJIGNvdWxkIHNvbWVob3cgdXNlIHRoaXMgdGVtcGxhdGUg
dG8gY3JlYXRlIG5ldyByZWNvcmRzLiBEb2VzIGFueW9uZSBoYXZlDQoJYW55IHN1Z2dlc3Rpb25z
IGZvciBtZSA/DQoJVGhhbmsgeW91DQoJQnJpYW4NCgktLS0NCglDaGFuZ2UgeW91ciBtYWlsIG9w
dGlvbnMgYXQgaHR0cDovL3AycC53cm94LmNvbS9tYW5hZ2VyLmFzcCBvcg0KCXRvIHVuc3Vic2Ny
aWJlIHNlbmQgYSBibGFuayBlbWFpbCB0byBsZWF2ZS1hc3BfZGF0YWJhc2VzLTUzNzc1MFNAcDJw
Lndyb3guY29tLg0KCQ0KDQo

Hi,
I am creating an online database that collects information on job 
postings. I was wondering if there was an easy way to create a template 
record with pre-populated data so I don't have to type all the information 
in the form again. In some cases only a few fields in the form will be 
different so I don't want to have to type the same info over and over.
My thought is that the users could flag a record as a "template" and then 
I could somehow use this template to create new records. Does anyone have 
any suggestions for me ? 
Thank you
Brian