Search results

https://ibb.co/k2sZ7wp I simply done that for both relationships and it fixed my issue.

so I thank you all for your help.

I need to make 3 more posts to post a picture of where I changed it

So I've solved it and it was as simple as pressing few buttons.... Sooo my sql code for my view looks like this now CREATE VIEW [dbo].[VwMainFaultsWorking] AS SELECT f.Symptom, f.symptom2, f.takenby, S.sdesc, S.Ssitenum, f.username, f.phonenumber, f.sectio_, f.sitenumber, f.cleartime...

Just to note the view's I use were originally queries in Access and everything worked once I moved them to Managment Studio if all went down hill from there. I just don't understand how my Faults Table updates normally yet the view from that table doesn't. I might have some Primary Keys...

Sorry you are right I was thinking of a different view that I was trying to get to work earlier. my bad in that case I have no idea why my view doesn't include new records after being created from scratch. I even tried making a view that is using FROM dbo.Faults Table and still same results

I've found something weird. So I've attempted to Drop the View and recreate it hoping that what ever i've added to my faults will display in SSMS but to my surprise after creating the view from beginning I'm still not seeing any new records and I have a slight feeling that it has something to...

and yes I close the Main form while my Addnew form is opened and reopen it once I close Addnew

Thank you everyone for replying. To be perfectly honest I don't really need that view to display the information Its just nice because I can use filter by Sites and Clients but if I use my Faults Table I wont see that information but there are other ways about it was just convenient to use that...

So come to think of it all I need is the View to just requery after new ticket is added or requery on load I have this in place but it doesn't work, will try it under ON Load Event but don't think it will help Private Sub Form_Activate() Me.Requery End Sub I feel like I will need to include...

I have a linked DB with view's and tables. Naturally I can't edit anything with in a view since i'm using inner and left joins but I have it set up that I can change the Tables and here's where the problem occurs. In general I'm creating a Help Desk system for my employer and I have to add new...