Solved

link fields in access

Posted on 2011-02-17
10
312 Views
Last Modified: 2012-05-11
Hi!
 I have a company that serves 2 type of services, I have a main form where I have customer information then I have a subform that there is a table where I enter witch service the customer is using (each service is a different record), then I have another subform where I enter additional information about the customer.
Now in the second form I have a field where I want to enter witch service is the customer registered for, if “service1” then it should be “service1”, if “service2”, then it should fill in the box “service2”, if both then it should be “both”

What’s the right way to get it done?
0
Comment
Question by:yoily
  • 7
  • 3
10 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34919291
I'm confused.

1. If you fill in the Service records in the first subform, then why are you entering the services again in the second subform?
2. Can you post some specifics on this "additional information".
Is it related directly to the customer (if so, then why can't this be in the Customer table)
If not, then is this additional information in a One to many relationship to the customer?

Even though, I don't see the need to have the Services listed in this second form...?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34919353
...anything special to display if a customer is new, and has no services assigned yet?
Display: "No services assigned"
0
 

Author Comment

by:yoily
ID: 34919430
so there is no solution for it?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34919897
"so there is no solution for it?"
I don't know, ...perhaps

The way I see this being done, ...yes... there is a solution.

You did not answer any of my questions, so I am not sure if this is possible with your setup...
0
 

Author Comment

by:yoily
ID: 34919933
i dont understand your question! thats the way i want it i need it for filling out a specific form
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 34920832
Are you saying that you won't even take a moment to explain what the "additional info" is?
Or explain why you need to enter the Services again in the "Other" form?
Yes or no?

The way I see it you only need two forms.
The Customer form and the Services subform.
You can use a function on the main form to display what the Customers "Service status" is...

In the big picture, you can have whatever design you want (as many forms as you like), but it seems to me that the main thrust of your Question was to display the "Service Status" for each customer automatically.

Using a function this is easily accomplished, however I am using the standard Junction table (Many-to-Many) design structure as the basis for my example.

I am not sure of your design's structure so I cannot be sure if my solution is applicable in your case.

See the attached screenshots of my approach.


JeffCoachman
untitled1.JPG
untitled2.JPG
untitled3.JPG
0
 

Author Comment

by:yoily
ID: 34920923
ok thats exactly what i want,
so how can i do it?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34921081
See attached sample file.

You will have to study it carefully and either adapt it to work in your database, or move your data into my sample.
Access-EEQ26828698JunctionTableF.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34921956
the code in the first sample was a bit "sloppy", so see this instead
Access-EEQ26828698JunctionTableF.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35285947
;-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now