Hi Drew, As you know, I am working on the section that describes how to build the forms for the tutrial. This is largely based on the files you sent me by early September. I must say that your design stroke me as very smart. For instance, it seemed to me that you decided to include the phone table (for patients) inside the form for patient data entry. This way you can both read and write to the contents without having to call an extra form. Is this correct? Is this what you call a sub-form?
I am working under the assumption that one can build the forms (number and position of lables, text entry boxes, etc.) with the help of the wizard and later add the extra functionality. Is this correct? Or do we need to build the forms from scratch some other way? I have also been working on the generation of the schedule (for therapists) promised in the tutorial by following your suggestion: dumping data to a Calc document. First I made a sample schedule in calc and exported it as a coma separated value document (.csv). This way I was able to understand the syntax used. I realized that this format does not include layout information (background colors, font styles, etc.) so I suspect that this would have to be produced by a macro. I am guessing that once a Base query organizes the data that we need, we will need another Macro to produce the .cvs file. Is this correct? My goal now is be to replicate the tables that you sent so that I can write about the process in the tutorial. For this I have some questions that I hope that you will have the time to answer: 1. How do you program the radio buttons so that the propper registry in gender is made? 2, How do you make sure that the timestamp is (automatically) included in the table? 3. How do I program the buttons so that they call the corresponding table (psychiatrist or MD)? It will be enough if you just shoe me one example. 4. And, how do I connect the patient data entry form with the patient phone table in order to make sure that the propper phone table is being shown? Talking about the time stamps, I have noticed this: The "patient" table SQL instruction set includes the following line: "Time of registry" TIMESTAMP, which to me means that Base should create a column called "Time of registry" in the table to hold a TIMESTAMP type variable. Now, the "Assignment" table includes the following instruction: "Date assigned" DATE DEFAULT CURRENT_DATE NOT NULL, I read this as saying: create a table called "Date assigned" to hold a variable of the DATE type which is to be NOT NULL. So far so good. But then DEFAULT CURRENT_DATE eludes me. Is CURRENT_DATE a function that would be set by default? If so, is this a function that comes with Base, OO.o or OOBasic? I read somewhere that the time functions that OOBasic uses are not compatible with the ones handled by Base. Is this info relevant? And connecting with the heading of this question, why does the "Patient" table not need a DEFAULT CURRENT_DATE instruction for "Time of registry"? Finally, you taught me that a CONSTRAINT can include a CHECK for certain search conditions. However, I have not been able to find what the search condition options are. Can you orient me? Thanks in advance, Mariano --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
