Setup Form

[kingnothingz]

Hi All,

I have a complex (to my standards) requirement. I have a field called a patientID, this is a field that is filled by the users that create the record. It has to have the hospital id at the start.
Example:
Hospital = Queen Victoria Hospital
PatientID = QVH001

This application that i'm developing now will be used by many hospitals.
1. I want to be able to have the users setup this Hospital ID themselves
2. This Hospital ID should appear as default for every PatientID

To achieve this, I'm thinking of the following

1. Create a form (frmSetup) that loads up on start of the application. Have the users type in the HospitalID
2. Use this HospitalID in the data entry form as the default value for PatientID.

My question is, how do i make a form that runs only once and how do i use the HospitalID as the default value??

Thanks for your help in advance

-kingnothingz

 

[matthewnsarah07]

Hi

I've seen a number of threads asking this type of question before and as far as I am aware it is generally a no no to make a field in a table dependent on another field in that table.

If you have [HospitalID] as one of a set number of hospitals and the [PatientID] as a unique Autonumber this would have the same effect ie you would be able to search for say PatientID 105 or for all patients with HospitalID "QVH"

This will make the setup alot easier for you

 

[DCrake]

In your application you need to have a settings table this will hold all information akin to the hospital where it is installed. When the application is first launched it needs to check whether the fields in the table have been populated, if not then it should open the setup form for them to complete, if already populated then it skips this process.

My initial questions are
How is the application being distributed
Is it going to be multi user
Is the database split FE/BE

David