Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table appears twice but only one populated
Message
From
25/09/2007 12:29:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Table appears twice but only one populated
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01256696
Message ID:
01256696
Views:
63
Hi Guys

I have this form for maintaining bus operator details.
Now one operator (company) may be owned by another operator (company).
So the Operator table appears twice in the DE - one with alias "OPERATOR1" as opposed to the default.

The subject Operator table has a foreign key to its owner (ie another operator rec - which, btw, I don't have as a cyclic reln. in the DD). Just for the purposes of this form I have that pointing at the operator ID of OPERATOR1 in the DE. SO on the form I have a listbox to the OPERATOR1 "version" of the table, so that the subject operator's rec can have its owner selected froom the listbox.

Now then, only trouble is the listbox is empty at runtime. Now I developed this a few years ago and I can't see that I let this flaw go in testing.

Any ideas? BTW it definitely is the same table USEDd AGAIN.

'ppreciate it

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Next
Reply
Map
View

Click here to load this message in the networking platform