Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View or Sql? How do i do this...?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
View or Sql? How do i do this...?
Miscellaneous
Thread ID:
00398920
Message ID:
00398920
Views:
64

I have an order entry system. There are 3 tables, Orders, Order_Items, and Inventory.

Question 1:

The Orders is a one-to-many into Order_Items.
Order_Items has a foreign key, ItemId, into inventory/

I need to show a grid of order items for the selected
customer. The grid should allow the user to add, change
or remove the order line items.

The line items can be picked from the inventory table.

So had had:



CREATE SQL VIEW v_Orders;
AS SELECT * FROM Order_Items;
WHERE ParentId = ?cCustomerId;
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform