Search results

Hello All: I have an issue that I cannot seem to resolve. What I want is that when a buyer sets the status of a productivity record to "Request Mgr Approval" an e-mail is sent to the manager maintain on their user tbl. So far what I have below only sends e-mails to ID 1 of the user table and...

OK I got it...I see what I did wrong. When I first created my child tbl I used a a Number field to house my FK. What I should have done was used a lookup instead to my main tbl's parent id. So the sub-form's Master & Child field now auto-populate the lookup FK. Well I suppose this is what I...

Ken, Thanks for your reply, this isssue is specific to how Access Services and Web Databases maintain relationships. It's not like normal, you cannot link to tbls together using the Relationship button...in fact, this is disabled. What you can do is create a lookup from one tbl to another by...

Thanks Ken, This was exactly my initial thought; but when I added the lookup from my subform's child FK all that did was create a drop-down. So now I have an unpopulated drop-down field...how do I get it to auto-populate so the delete cascades? I cannot expect my users to maintain the FK...

It's a Access 2010 .accdw...I suppose I could save as a local .accbd...would this work for you?

Hello All: I embedded a subform within a main form by dragging it and then using the Link Master Fields ID from the main form's tbl to the Link Child Fields in the subform's FK. So, as I preceive it, the form itself is maintaining the relationship. I've included a screenhot so you can see what...

Thanks, I was able to resolve my issue.

Still looking...

Hello, I am attempting to use a LookupRecord in conjuction with SendEmail to send an e-mail notificiation. Basically when a records Status within a nested sub-form (ProductivityAmount) reflects "Request Mgr Approval" I want an e-mail to be sent to that mgr. The User (Assigned Buyer) is...

Thanks, I should mention this is an Access Web Database, all I can use are macros...code isn't supported on a web database.

Hello All: I have a Main tbl where I am storing a lookup leading to a User tbl. Within the User tbl I am maintaining: User Name, User E-Mail, Manager & Manager E-Mail I have set the Main tbl to display all of this information within its lookup, when a record is updated I was hoping to use...