Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Schedule table
Message
From
01/07/2009 08:54:21
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
01/07/2009 08:46:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01409304
Message ID:
01409544
Views:
37
>>Thank you for all suggestions
>>
>>
>>I was considering two options
>>
>>
>>1- Create a table for dates and a child table for appointments
>>(in this case appointments are records)
>>
>>2- Create a unique table where date and appointments are fields
>>
>>As the second option seems easy to me, I would like to know
>>if there are chances of having problems if I choose it
>
>With date, do you mean like, "5 Jan. 2010"? Why would that be in a separate table? I would just put it as a field in the appointments table.
>
>Or what is the information that might remain in a separate table?

Holidays.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform