General information
Forum:
Microsoft SQL Server
Hello Enmanuel,
Thanks for your feedback. I was leaning for your solution. Since the 'Orders Detail' records will contains lots of records, it is better to minimize the number of fields.On the other hand Products and Services table will have few records and I can afford to have many fields. For example tack_stockLevel does not apply to services.
>You may also want a type table where you indicate the different types of >items just in case you want to add more than just services & products, >let's say for example "no billable".
Good idea. I did not think about it.
Thanks,
Sergio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only