3 Combobox use in Visual foxpro 9

[rajeshrmg]

I want to use three combobox in a single form with three table

combo1 display the field1 of table no 1 and also display the field1, field2, field3 of table no 1's data in text1,text2,text3 after that combo2 display the field1 of table no 2 and also display the field1, field2, field3 of table no 2's date in text4,text5,text6, another combo3 display the field1 of table no. 3 and it also display the field1, field2, field3 of table no 3's data in text7,text8,text9

kindly give me solution its urgent. if you have a programme then send me in my mailid rajeshrmg@gmail.com

 

[Mike Lewis]

Rajeshrmg, welcome to the forum.

I'm sure someone will be able to help you with your problem. But please understand that we are all volunteers here, and we give our time freely to our fellow VFP developers. Asking for an urgent reply is not likely to get you anywhere.

Also, any help you get here is given on the basis that it will be of use to other forum members and developers.
We're happy to give general advice, and even suggest snippets of code, but you can't expect us to send you a complete solution by email.

I hope you won't mind me pointing these things out to you.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Mike Gagnon]

Aftrr Mike's comment, it is not clear in your post what is the problem. Can you explain?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Olaf Doschke]

I second the second Mike (Gagnon),

What is your problem? Is it the class design of a solution, binding the fields? Is it how to bind a combobox?
Do you know there is a solution project in the VFP installation folder? You'll find it with _SAMPLES, eg CD (_SAMPLES) and then MODIFY PROJECT ?, now navigate into what sample project folder interests you, Solutions is a sample project with many detail solutions.

Also take a look at task pane Solution Samples tab, which addresses that exact project. You can answer very basic questions yourself very fast and play with solutions and read source code. And by the way, the task pane is part of VFP9, but you didn't even tell, what version of VFP you're using.

Bye, Olaf.

 

[Olaf Doschke]

..sorry, pardon me, you're stating VFP9 in your thread title.

Stil, what is your exact problem with the task? It's quite clear what you want to do, but not what you don't know.

Bye, Olaf.

 

[rajeshrmg]

I m very sorry to get urgent word in my thread, I am a new programmer of Visual Foxpro in last time I am using foxpro 2.6 for dos on dos no combo box used so it is very new for me.

 

[Olaf Doschke]

So you have no idea on how to use the combobox. The solutions samples will get you an idea, then.

But perhaps you also don't know any visual controls quite well. Star with the textboxes, that's much easier.

1. Put the tables your form should work with in it's DE. For some reasons that's done different in larger applications, but for a start it's simple and works
2. Drag the fields you want to display in textboxes from the dataenvironment to the form.

Now you can inspect the properties of the textboxes and see how VFP did use the controlsource of the textboxes.

First do that and then we can talk about the comboboxes. Start with one table only. I plan to guide you into creating a class you can then recycle for the other two tables, but we'd get to this later.

Bye, Olaf.

 

[Mike Lewis]

Rajeshrmg,

As you're new to Visual FoxPro, it would be worth your while to spend some time getting to know the general concepts of visual controls. As Olaf suggested, start with a textbox, because that's much easier. Experiment with setting its properties, and see what effect that has.

When you're ready to to back to the combo box, I suggest you start by reading the Help topic called "Combo Box Control". It contains information about the most important properties and methods that you will need to know about.

Hope this helps.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[JRB-Bldr]

If you are coming from FP to VFP, you might want to spend some time looking over the free, on-line VFP tutorial videos at:

http://www.garfieldhudson.com/FreeVideos.aspx

Also there are a number of books on VFP at:

http://www.hentzenwerke.com/catalog/zcatalogsubject.htm#visualfoxpro

Another suggestion - I'd recommend staying away from the Wizards in that they help you build Forms, etc, but they do it in THEIR OWN WAY and you end up with INHERITED classes, etc.

It is far better to build Forms by hand where you can much better understand what is going on at each part of the code.

Good Luck,
JRB-Bldr