Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

form/subform design access

Posted on 2011-10-01
7
325 Views
Last Modified: 2012-05-12
I have three tables:

Clients, who have many
Files which each have many
Invoices.

The tables are therefore linked that way.

I want to have cleints as the main form
That form will be tabbed.
On the first tab will be a Files. I have had no problem in building the subform
On the second tab will be invoices
What i need is the best way to do this:
To click on a File in the subform (first tab) and go to the corresponding Invoices on the next tab, and to be able to create a new invoice ID etc
There would there for be a clickable link from the (say) file ID to the invoices for that file.










0
Comment
Question by:topUKlawyer
  • 4
  • 2
7 Comments
 
LVL 6

Accepted Solution

by:
kswathi earned 250 total points
ID: 36896221
If the file is only single selection then just create  invoices and a Combo box to select with the files corresponding to the client in the  third tab if it is ok (if the files are not many)  or what you think is also nice.
0
 

Author Comment

by:topUKlawyer
ID: 36896469
i am uploading the dbse fr you comments.

what i want to do is to be able to click on a file number in the first tab and then
go to the corresponding record on the invoices tab.
trial.accdb
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 36897000
test this, click on fileId from the files subform
trial.accdb
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:topUKlawyer
ID: 36899054
that upload seems a bit problematic but i cant work out why...

This is what im trying to understand:

If I have a table/form with clients ID then a sub form to reflect one client to many files, can i then make a sub sub form with one file to may invoices and then retain the link to the same client.
In other words for that one client with many files, when you select a "file' will the invoices sub sub form show the invoices for that selected file.

Can this be done with a sub sub form and how is it linked properly to the forms "above"

I have some familiarity with Master and Child links.



0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36899546
di you test the revised sample db. ?
was there any problem using the revised sample db ?
0
 

Author Comment

by:topUKlawyer
ID: 36905271

 I have sorted it, I think. In retrospect the sample I uploaded was not too good and this may have caused it to behave oddly.

I wont bother you with the details.

I have done some further work on my own and having found a good example  i used an intermediate text box as a master and child link between two tabbed forms

I now have a much better understanding of sub forms, and sub sub forms.

Thanks for your help guys


0
 

Author Closing Comment

by:topUKlawyer
ID: 36905278
Points awarded for responding and being helpful
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

861 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