I have forgotten the propper formatting to use while creating a database.

[AuroraMay08]

I work for a healthcare practice and am trying to create a database where I can enter all of my information on one form and there will be 4 databases that house all of the information.

I would like there to be the following databases:

1. patient lookup info (chart #, full name, date of birth)
2. insurance carriers (company name, billing address)
3. adjustors (full name, phone number, email, fax number, link to database #2 company name)
4. insurance claims (claim #, body part injured, date of injury, link to database #3 full name, link to database #2 company name, and link to database #1 chart #)

I thought I had created those databases properly as well as a form using the form wizard, but I am having difficulty with the form allowing me to input information without throwing back errors.

I am sure that I am missing something simple in my creation of either the form or the relationships in my databases.

Any guidance on where I should start looking would be much appreciated.

Thanks!

[andy49]

I think we'd need to know more about the relationships and that structures. And what "errors" keep getting thrown back.


Sent from my iPhone using Tapatalk

[orange]

Please tell us more about this:

"there will be 4 databases that house all of the information."

[AuroraMay08]

First of all: I would like to correct a term I used in my original post - I did not mean to say 4 databases, I should have said 4 TABLES.

I did some more digging and tried to do some self-teaching based on a few things I found and I realized that I will need much more than 4 tables.

I currently have the following tables and relationships set up:

I am fairly certain I have made an even bigger mess of things as now I can't create a form without Access crashing in the middle of the form wizard. I need the form to contain a field for each item listed (except the AdjustorID, CarrierID, and Address ID if it is not required to make the form useful). Have I created too many relationships and superfluous tables?