SELECT     dbo.MainTable.DateCreated, dbo.InitialsListing.Initials, dbo.MainTable.CustomerNumber, dbo.InitialsListing.AdvocateName, 
                      dbo.MainTable.Supervisor, dbo.MainTable.Complete, dbo.MainTable.FirstNotify, dbo.MainTable.SecondNotify, dbo.MainTable.ThirdNotify, 
                      dbo.MainTable.AdvocateInitials
FROM         dbo.InitialsListing INNER JOIN
                      dbo.MainTable ON dbo.InitialsListing.Initials = dbo.MainTable.AdvocateInitials

quote:

---

Originally posted by homeguard

I have two tables, a data table (MainTable) that contains a user initials and other empty rows and then i have a user table.

I also have an inner join view with the initials from both tables as the joining field.

I want the users to be able to modify the data table (MainTable) but also display the users name field.

here is the sql of the view:

SELECT     dbo.MainTable.DateCreated, dbo.InitialsListing.Initials, dbo.MainTable.CustomerNumber, dbo.InitialsListing.AdvocateName, 
                      dbo.MainTable.Supervisor, dbo.MainTable.Complete, dbo.MainTable.FirstNotify, dbo.MainTable.SecondNotify, dbo.MainTable.ThirdNotify, 
                      dbo.MainTable.AdvocateInitials
FROM         dbo.InitialsListing INNER JOIN
                      dbo.MainTable ON dbo.InitialsListing.Initials = dbo.MainTable.AdvocateInitials

---

quote:

---

Originally posted by homeguard

yes, i want the user to beable to update the main table and also display the values of the users name, i think this is something i need to do with the frontend.

---