473,323 Members | 1,537 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Access front end - SQL back end question

These are my tables:

Client
------
ClientID

Provider
---------
ProviderID

ClientProvider
---------------
ClientID
ProviderID

CostCenter
------------
CostCenterID
ProviderID

ClientCostCenter
------------------
ClientID
CostCenterID

ObjectCode
-------------
ObjectCodeID
CostCenterID

PayrollPositionCode
----------------------
PayrollPositionCodeID
ObjectCodeID

CostSheet
-----------
CostSheetID
ClientID

ProcedureCode
-----------------
ProcedureCodeID
CostSheetID
ObjectCodeID

I have SQL Server 2000 back end with Access 2003 front end.

Now it gets complicated, but I will try to explain what I need.

I have a Client main form, and I need to add a subform with the
following:
ProviderID, CostSheetID, CostCenterID, ObjectCodeID,
PayrollPositionCodeID, ProcedureCodeID, and some other fields.
These need to be combo boxes, and their values should depend on who is
the client. Then if a client is assigned to providers A and B for
example, those should be the only options under ProviderID combo. If I
select provider A, then the cost center combo should only give me the
option to select cost centers that are assigned to that provider (for
the specific customer), and etc.
Finally when I am done with my choices, they should be saved in a
table.

Does this make sense? Any help would be much appreciated!

Thanks!

May 26 '06 #1
2 1202
sounds like you need something like this:

http://www.mvps.org/access/forms/frm0028.htm

May 26 '06 #2
Is that my only option?

Thanks

May 30 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: rickcheney | last post by:
I just changed my Access 2002 database to a SQL Server ADP project. I had a form where the user entered a value into a text box and when a command button on the form was clicked a Report was...
3
by: ARobi | last post by:
I have developped an Access database with a lot of coding. The size of the database without data is about 5 meg. I am ready to copy the database to a client PC which already has a legal version...
3
by: Alienz | last post by:
Hey guys heres my network question: 1- when I selet Tools-startup and limit the access to access, it applies to all of the users on the network who are accessing the database through a network...
8
by: Henry Craven | last post by:
Hi Everyone.. Been forever since I've posted to the Access newsgroups, and even longer since I've needed to post a question, but I've never had to use or try Access on a Terminal Server so I'm...
2
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection...
1
by: Julia | last post by:
Hello there. I have a question somewhat related to this topic, and I don't know where else to go. I hope somebody can help. I've created a database in access, that I'd like to share with less...
35
by: robert d via AccessMonster.com | last post by:
I was asked to provide a proposal. I provided a proposal on my application and the prospective client likes what I have but is wary of it having been developed in Access. I don't understand this...
5
by: Kip | last post by:
I have an office with approx 8 people. I have used Access with a Form on my personal PC for client records. I was wondering if I could put the Access table on a server and put shortcuts on each...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
9
by: Moor | last post by:
I have a .MDB back-end database that is created with Access 2.0. And multiple front-end mdb's, some are created by Access 2.0, and the rest are created by Access 2003. The fron-ends had table...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.