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!