Can't Add records to tables (New)

[Pantinosm]

Hi to all and please eexcuse me if my question are very simple for you.


I have a patients databasein which i have a patients table that is connected with 4 other tables via PID (one to many).
I the have a form in which i select my patient, and i have 4 individual buttons for 4 other pop up forms to enter or edit the information based on which patient i select.
The problem is that whenever i add a record i get an error that i have a record related in my main Patients table. What changes i must do?
I am attaching the file.mydb.zip The problem comes through my main form.

Thank you for any help provided.

[orange]

I don't work with macros so haven't looked into the code. I don't understand the Patient table attributes - seems many should/could be in some other table(s). You really haven't told us WHAT the database is about or what some of the "business rules/facts" are.
I did attach a jpg of your tables showing all the fields. It may help others who read/respond to your post.
Good luck.

[Pantinosm]

Forget about the fields in Patients table except the 2-3 first ones, the other dont matter at all. The whole system is based on a patients, and his different treatments that are in other tables. If you go to Main form, and select one patient, try to go lets say to Laser Treatment by pressing the button. When you try to add the record it doesn't let you.

I think this is something very simple, i just don't understand the logic and how to work around it.

[orange]

The data structures - tables and relationships - are much like the foundation of a building. For me it's hard to forget about it.
You can deal with the forms and buttons, but I'd recommend getting your structure set up to support your needs.

Good luck.

[Pantinosm]

Dear orange i really appreciate what you say, but i came here for help to my problem, and i don't get any. My structure is ok, i don't see any wrong. I just want to know why i get these errors.

[orange]

Suggest you identify that you are working with macros and need some help. As I said, I don't use macros and can not comment on their structure/use....

I do see issues with you relationships -things that I would not have or suggest - but I don't know your business and business rules.

Here is a tutorial that will help with data structure -- for reference if nothing else.
http://www.rogersaccesslibrary.com/T...lationship.zip

Again, good luck and stress the fact you use macros and need someone to review your database.