Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binding grids to more than one table
Message
From
25/10/2005 04:21:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01061766
Message ID:
01061772
Views:
11
>I have 2 tables which are related by a key named artikey i.e. table.artikey=table2.artikey. I want a grid which shows some fields from both tables but only allow edit on table2.quantity field. Is this possible?? I would like to bind the grid to the table rather than build a cursor.

Neil,
-Set columncount to total number of fields you want to show.
-Set controlsources to tablename.fieldname ( table1.fieldX, table2.FieldY ...)
-Set Enabled or ReadOnly property for columns as you wish.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform