Windows 7 
Access 2010 (version 14.0)
Hi there.
I have an ms access system for registering and calculation data from eight different types of ultrasound exams an d making their respective reports. I have an initial logon form (I found it at internet), a second form (only for showing the logo) and the main screen with menu to the eight different exams.
There’s one table for the logon (name, password, level), other with patients data (name, address, phone, etc) and other eight for each kind of exam (gynecol, obstet, breast,…) with different fields and different kind of data (so that’s for I needed eight different tables). Each one of the eight forms has a form and a subform, linked to the first with name field. At the first, the general data and at the sub, the specific exam data.
As this system was only for myself, everything worked ok. Each report has at the heading the clinic logo and name, at the end of the body my name and professional registration and at the footing the clinic address and phone. Currently, some friends are requesting me copies of this system and I think I should make a commercial version of it.
But here comes the deal: I need a way to register a professional and his professional registration number with a specific clinic, logo clinic and address and phone in a way that everyone who logon, when do this, has this information automatically available at the respective fields when the reports come to be generated.
I think that it may be possible doing the following:
1. First adding more fields to the logon table (name, password, level, profname, profnumber, clinic, clinic_address, clinic_phone)
2. a query with data from different tables (logon table and exam table).
Until here I think it’s easy. What I can’t think is how to make the query request these data only using the associated personal data from the professional specifically logged.
Any help will be very welcome.
Than k you very much.
Ivan Sinigaglia (Brasil)
Reply With Quote
