add new record in lookup table

[jjatcal]

Hi,

I have a lookup table with set values. I use this table to populate data in a members table. How do I add new entries into the lookup table directly from the members table?

For example, the lookup table is PhysicianSpecialty. It has records for Cardio - Cardiology, OT Nurse - Operation Therapy Nurse, etc. This field is made available in the members table. If I have a physician who is not listed in the PhysicianSpecialty lookup table already, then I cannot chose it from the members table. How do I update directly a new physician type in the members table without adding it first in lookup?

Thanks.

 

[ZmrAbdulla]

Here is the link to MVPs.org
Add item to combo box using OnNotinList event
regards

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?