[MS_AccessPros] Problem with SQL backend access frontend using table source as value list for form that calculates cost

 

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/
www.texasbeyondhistory.net

State Certified Repository

 

__._,_.___

---

Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

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

.

__,_._,___