[MS_AccessPros] Re: Problem with SQL backend access frontend using table source as value

 

Using the SQL Server management studio, right-click on the table and select Script>Create Table>New query window. Copy and paste the "Make Table" SQL here so we can see what the script is doing to make the table.

FYI - You might want to remove all your contact info in your email signature to prevent spammers from getting it.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <marybeth.tomka@austin.utexas.edu> wrote :

Morning,

 

Follow up on my posting from yesterday.  I create a unique constraint on the field that I am trying to link the tables with and now I get a message about foreign key violates "alter table" functions.  Really could use some help here. 

 

Marybeth

 

Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL       
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone

www.utexas.edu/cola/tarl/
www.texasbeyondhistory.net

State Certified Repository

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, June 20, 2018 4:32 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Digest Number 9099

 

MS Access Professionals Group

1 Message

Digest #9099

1

Problem with SQL backend access frontend using table source as value by "Marybeth S Tomka" mstomka

Message

1

Problem with SQL backend access frontend using table source as value

Tue Jun 19, 2018 11:15 am (PDT) . Posted by:

"Marybeth S Tomka" mstomka

Good afternoon, I really hope you all can help me resolve an issue I am having. I recently migrated an access database to a SQL backend and an access front end. In the original access database I had a form with a subform that calculates the costing for a service. Several of the fields are linked to a value list table to control entries as well as not storing these service values in the data table. Now I can't add records through the subform or the main form with the subform activated. I think it must have something to do with the relationship between the tables, but I can't get them to be a one-to-many and I have tried all the usual suspects for error trapping. What is a not so obvious reason for not linking correctly?

Marybeth

Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone
www.utexas.edu/cola/tarl/
<http://www.utexas.edu/cola/tarl/%0b>www.texasbeyondhistory.net<http://www.texasbeyondhistory.net/>

State Certified Repository

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

 

 

Marybeth

 

Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL       
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone

www.utexas.edu/cola/tarl/
www.texasbeyondhistory.net

State Certified Repository

 

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___