Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating mult. value mysql index with date_format
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01340137
Message ID:
01340640
Views:
7
Bob,

I don't see why you need date part for FK and a view can be sorted with ORDER BY or creating additional indexes on the view.
If , for whatever reason, you need index on both fields, than
CREATE INDEX ACTSTAFFAC ON CONTACTS (ACTSTAFF , ACTDATE) 
>
>Well my thought ws to use foreign keys to maintain Parent/Child table relationships, similar to the .dbc, and then use remote views. But alas, still absorbing the concepts.
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform