I will first say I hardly know what I am doing. I have spent literally hours (all weekend) trying to solve this problem myself using the Base 6.4 manual and searching some forums. This is my first time using Base and it is pretty frustrating.
Now that my gripe is out of the way, I am building a sports trading card database with several tables and a data entry form. I have a main table – card collection, and several other tables I have tried to create so that I can enter some of the data using list boxes: Card Type, Card Year, Card Publisher, Card Brand. Each has its own primary key. I have entered relevant data into each table along with the key. The screenshots on this post will show the format of each table and the table relations I have set up, and the error message I get when I attempt to enter data using the “Card Type” and “Card Year” list boxes: integrity constraint violation - no parent.
I have scoured all of my tables for missing data, or blank cells and there are none. In the “Type” table there are nine entries but in the main table I have used only three so far. The ID key formats match from table to table (except for, oddly enough, the “publisherID” and “brandID” fields but both of those are working correctly on the form). I chose “tinyint” as the ID format in order to save space–could that be the problem? Or could the problem be in the way the relations are set up? I have them all set to “update cascade” and “delete cascade” but I dont know if that is correct. I noticed the TypeID and CardTypeID relation has the TypeID = 1 : CardTypeID = n and I though perhaps that is backwards but I cannot reverse it. Or maybe it is something else entirely that is causing the problem?
table format screenshots:
main table Imagebin - Somewhere to Store Random Things
Type table Imagebin - Somewhere to Store Random Things
Year table Imagebin - Somewhere to Store Random Things
publisher & brand table (for comparison) Imagebin - Somewhere to Store Random Things
list box and form screenshots
type list box properties Imagebin - Somewhere to Store Random Things
type list box SQL Imagebin - Somewhere to Store Random Things
publisher list box properties (for comparison) Imagebin - Somewhere to Store Random Things
publisher list box SQL (for comparison) Imagebin - Somewhere to Store Random Things