>>I am beginning to experiment with setting up persistent relationships for the first time and I am running into a couple of problems.
>>
>>I have a database that has an inventory table and a category table and a sub-category table. Example categories might be 1-Band 2-Fretted Instruments. Example of subCategories under Category 1 (Band)might be 1-Piccolo, 2-Clarinet, 3-Saxaphone, etc and under Category 2 might be 1-Acoustic, 2-Electric, 3-Banjo, etc.
>>
>>Anyway I have a form established with 2 combo boxes cboCat has the category table set as the rowsource and cboSub has the rowsource set to the subcategory table.
>>
>>I was thinking that if I pick a category 2 from cboCat that only the subcategories related to category 2 would show in cboSub. This isn't the case .. all subcategories show in cboSub not just the ones related to the category chosen in cboCat.
>>
>>I do have a persistent relationship set in the database between the foreign key in the subcategory file and the primary key in the category file.
>>
>>Thanks,
>>Paul
>Paul,
>I really not to mean it cannot be done that way but I suggest not to use it with relations. For comboboxes managing SQL is a lot easier IMHO.
>For second combo you could leave both Rowsource and Rowsourcetype at their default (none) :
>
>lcSQL = "select subCat "+;
> "from myChild "+;
> "where subCatParentKey = thisform.catCombo.value "+;
> "into cursor myCursor"
>RowSourceType = 3
>RowSource = lcSQL
>
>* subCombo.when or gotfocus
>this.requery()
Advantage this is free of relations and once you build correct SQL you get what you want.
>If subCatParentKey (category link key) is not char, you should take that into account and do conversion (combos return value as char).
>lcSQL variable usage is not necessary (think as #define). Not written directly to combo PEM sheet because long SQL cause headeache there.
>Cetin
Hi Cetin,
Thanks....I am also having a problem with the data entry form for the subcategories. I am beginning to wonder whether or not I should even set up any persistent relationships in the DBC. Is there any recommendations or guidelines out there on whether or not persistent relations are a good idea or not?
Paul