Integrity constraint violation when inputting data into a form using a listbox

[anasteso1454]

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

table relationships Imagebin - Somewhere to Store Random Things
error message 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

[Ratslinger]

Hello,

Have had an initial look at your images. Images are not helpful in this manner. Requires jumping around from screen to screen just for some basic comparisons. Instead, it is better to post a sample database (no personal or confidential information). Please do that here as you screen shows many problems. As you state this being your first time with Base (this is only a front end to a database which you have not stated the one in use), you should not be jumping in to the deep end of the pool if you do not know how to swim.

Some examples. In Main table you placed CardBrandID but there is no table this is associated with. Other ID types are not consistent as stated (tiny int - better as Integer with auto increment). Type table shows field of SportType but in the relations screen there is no such field. You should avoid using spaces in field and table names. You have a mixture - no consistency. There is more.

Please post (in edited question) a sample Base file.