Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to design this view?
Message
From
01/07/2001 23:43:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to design this view?
Miscellaneous
Thread ID:
00525750
Message ID:
00525750
Views:
49
Hi,
I have 5 tables:
Table : tblBacklog
Fields :
    CtrlCode     (Primary)
    LogCode
    RefDept      (Relation : tblDepartment.RefNo)
    RefDelay     (Relation : tblDelay.RefNo)

Table : tblEmpAssign
    CtrlCode
    LogCode
    Emp_Code

Table : tblEmployee
    Emp_COde
    Emp_Name

Table : tblDepartment
    RefNo
    Dept

Table : tblDelay
   RefNo
   Delay

I would like to combine all of these to be a cursor as the following
tblBacklog.CtrlCode
tblBacklog.LogCode
tblDepartment.Dept    
tblDelay.Delay
tblEmployee.Emp_Name

I would like to allow use to update the fields of the above, tblBackLog.RefDelay, tblBackLog.RefDepart, tblEmpAssign.Emp_COde
How should I design it?

Thankl you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform