At this point I am wondering where I can buy large quanities of fertilizer to send to my university in retailation for there choice of COBOL for there intro to DBs.

Ive been working on this on and off for a few weeks - spending most of my time out actualy collecting data to use in the form. Indeed last week I spend a more than half mt times looking for PCB's in light balasts, and asbetos everywhere else in a to-be-torn-down hospital :)

Not only do I want my combo box to work like I would think a normal person would think as the default way, I want to use its value to populate some other controls when changed. Based on not knowing RDBM theroy, at this point looking for a quick and dirty solution to the exactly the same problem in 3 forms and more importantly VFP giving me a big circle with a line trhough it when trying to make relations (and the poor documentation on weather this will help or not).

To that end in the interactive_change method of my customerid combobox I have

SEEK this.value ORDER TAG customerid IN customers
thisform.pageframe1.page1.clientname1.value = clientname
thisform.pageframe1.page1.projectname1.value = projectname
thisform.refresh()

Which looks like it should do what I want it to do. But it only seems to get realy confused, blanking out most of the other controls on the form. And it definitly confuses the standard off the shelf txtbtns. (which dosent seem to understand combo boxes at all, not greying them out when it creates itself, lice it should do, and dose to everything else)

I would have thought this whole proble would be a common one - selecting a adderess block from a customer# in invoices, for example. And I figured out how to do it in Access[1] about 5 minutes into my total time using it. Indeed there was a wizard to that end. Which proves one of two things (or both) - VFP is unecessaraly complex [for my project] and/or I should find a rappidly moving lead projectile to put my head in front of...


[1] I can only imagine that flame wars that this will start. I dont know why - it is clear that real DB programers program in 370 assembler-h[2] or LISP[3].

[2] Nevermind or laugh or cry. Its been a long day and its only 1020.

[3] /me wonders about doing a oodb in EMACS. [5]

[4] Fatal Exception 0E[6] : unreferenced footnote.

[5] No, I dont actualy

[6] 0E realy means "your processor is too hot"