Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many select statement - want one row with data
Message
From
20/05/2006 11:08:19
 
 
To
19/05/2006 21:43:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01123686
Message ID:
01123747
Views:
14
Thanks for the response. It is still helpful to find out that something cannot be done (at least easily), so i'm off trying to find the solution.

I can see why it is easier to use one-to-many table solutions rather than a spreadsheet like approach, which is what i've been doing (ie a table with fields lname, phone1, phone2, phone3). one-to-many is much more flexible. but now that i want to put this information into a grid or listbox where people can see each contact with all their information in one row, i'm wondering about it. but the flexibility with design does make the initial part much easier.

As someone who is still learning a lot about vfp and programming, i'm thinking about how other more efficient programmers program. Often I think there must be an easier way than what i'm doing. sometimes it's helpful enough to know that there isn't.

Thanks,

Paul
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform