Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same table twice in a DE
Message
From
04/07/1999 13:18:12
 
 
To
04/07/1999 11:54:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00237333
Message ID:
00237348
Views:
12
Create a view of the table as SELECT * FROM table. Have the base table and the view opened in the DE. This should work OK for lookups like Comboboxes, but might get complicated if both table abnd view are read/write.

>How can I open the same table twice in a forms DE and have the same relations with other tables. The problem is that I have two combo boxes that need values from the same table. But I don't want the record pointer moving when I select a value for the second combo.
>
>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform