edit look-up table 
Author Message
 edit look-up table

I am developing a pharmacotherapy management database that will be used
by a number of pharmacists. I would like to have a look-up tables
attached to pharmacist name and service so they don't have to continously
enter their name and service. However I also need to have the option to
allow new pharmacists or different services to be added to the lookup
tables. Is it possible to have them enter their name & service only once
and it will be then added to the lookup table?

Renee Crowther



Mon, 06 Sep 1999 03:00:00 GMT
 edit look-up table

You presumably have a menu setup to guide them through their
options...one choice should allow editing of the lookup table just as
if it were a regular data table....

Quote:

>I am developing a pharmacotherapy management database that will be used
>by a number of pharmacists. I would like to have a look-up tables
>attached to pharmacist name and service so they don't have to continously
>enter their name and service. However I also need to have the option to
>allow new pharmacists or different services to be added to the lookup
>tables. Is it possible to have them enter their name & service only once
>and it will be then added to the lookup table?

>Renee Crowther



Tue, 07 Sep 1999 03:00:00 GMT
 edit look-up table

I think you don't want them to access the lookup table.
If so you can for instance

1       use view() to gether the name and service and add a record to the table
with OPAL.
2       Create a dialogform to gether the information and adding it to the lookup
table
3       Use getusername() to check if the person is known to the database
4       Set a password for the lookuptable so they can only add data.

--
D. Stam
StamData
Paradox applications & trainingen
fax +31235272331



Quote:
> I am developing a pharmacotherapy management database that will be used
> by a number of pharmacists. I would like to have a look-up tables
> attached to pharmacist name and service so they don't have to continously
> enter their name and service. However I also need to have the option to
> allow new pharmacists or different services to be added to the lookup
> tables. Is it possible to have them enter their name & service only once
> and it will be then added to the lookup table?

> Renee Crowther



Fri, 10 Sep 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. PDOX 4.5 [DOS] - Editing Lookup Table

2. Table lookup on drop down edit?

3. SQL 7 and concurrent look-ups

4. look ups

5. Look ups

6. Problems with look-ups

7. Look-ups on two fields

8. Help for Look Ups

9. Slow Database look ups

10. Lookup Tables to Lookup Tables

11. UPS SHIPPING TABLES

12. Looking for components to display/edit CCIT Gruop 4


 
Powered by phpBB® Forum Software