Recent content by jvicchio

I took out my hyphens on the violation table. I had them in their because that is when I received the data. Plog I see what you mean regarding the names not matching properly but because the doctors are licensed with the state they usually have to use their full Names and Medicare only pulls...

It was that easy! Goodness gracious I have been sitting here getting angry. Now I have to fix the query itself because it gave a (Not Responding).

I have a database built that stores medical office location. I have some new data about 60,000 lines on people who have Violations with Medicare and are no longer allowed to bill medicare. I was trying to match up the different people that match in my database and the violations. The data is...

I did the latter with the extra table. I have one table linked via my Primary key (Tax Identification) to store the attribute and another stand alone table storing all the different types of clinics (28 now). Thank you for all your input :D

I have reviewed the subtype and it appears I have designed something similar. I have the Tax Identification which is the clinic identification kind of like a person. The 11 other tables are subtypes to the clinics. One issue I am having currently is adding a field to indicate if the facility is...

I am sorry I did not post more information. I did not want to ramble... I handle validating medical clinics ownership. I track locations, doctors, workers compensation, bank accounts, property owners... etc. I have attached a snapshot of my relationships for you to review. Basically I store...

Thank you I have a State table that includes all the State abbreviations which I think will do the same thing. I was just reading some threads and people indicated it was unwise to have Lookups in the table itself and to use Forms. The form method confuses me right now and I haven't done...

Hello everyone I work in the insurance industry and designed a database and I am in charge of validating medical providers and track ownership of the clinics. I have 12 tables tracking different aspects of ownership, doctors etc. Recently I came up with a tracking system to differentiate...